4 Replies Latest reply on Jul 28, 2015 2:36 PM by DamianWhite

    Can't get defaultResut to work in Case calculation

    DamianWhite

      Title

      Can't get defaultResut to work in Case calculation

      Post

      Another newbie question.

      I'm wanting the Case calculation to return a set of values relative to what's in a specific field, with a default value (specifically, 00) when that specific field is blank.  Using this following calculation:

      Case(Sample Sub Type="Tumour";"TU";Sample Sub Type="Adjacent";"AD";Sample Sub Type="Healthy";"HE";Sample Sub Type="Negative";"NE";defaultResult="00")

       ... I get the returned values referencing the Sample Sub Type okay, but I keep getting a 'The specified field cannot be found' error when I try to use defaultResult. 

      What am I doing wrong ..?