0 Replies Latest reply: Jun 13, 2017 8:34 AM by David Pardoe RSS

    Strange If function behaviour...

    David Pardoe

       

      I have a "drop down" widget on a report that can take 3 values: "Region", "Office" or "Top25". Whichever is selected is stored in the variable vBaseline.

       

      If I create a "Text and Image" object on my report and use the following expression:

       

      if(vBaseline='TOP25',

      TOP25',

      if(vBaseline='A_CON_OT_REGION' or vBaseline='A_CON_OT_OFFICE',

      'Region or Office’,

      'XX'

      ))

       

      ...it behaves as expected: When I change the dropdown object the value returned by the expression is as correct. If, however, I now replace 4th line as per below it misbehaves:

       

      if(vBaseline='TOP25',

      'TOP25',

      if(vBaseline='A_CON_OT_REGION' or vBaseline='A_CON_OT_OFFICE',

      Avg({1<$(vBaseline)=P()>}A_CON_DS_P_LEAVE),

      'XX' 

      ))

       

      If I select region or office in the drop down then I get the correct value (as calculated by the 4th line). If I select "TOP25", however, I now get a NULL response!!!!

       

      I would love to able to solve this one!