2 Replies Latest reply: Dec 21, 2017 3:36 PM by Martha Parsons RSS

    Calculated Dimension If Statement

    Martha Parsons

      I have an expression I need to make a calculated dimension so I can suppress null values (I only want to show values that have a 1 in the field).

       

      this is the working expression:

      If(Count({$<SITE={$(=[Base Site])}, FIELD1=, FIELD2=>} TOTAL<SITE, MARKET> FARE) = 0 and FARE = Min({$<FIELD1=, FIELD2=>} TOTAL<SITE, MARKET> FARE), 'Missing')

       

      I, of course, didn't work when I put it in the calculated dimension

       

      I also tried this in the calculated dimension:

      aggr(If(Count({$<SITE={$(=[Base Site])}, FIELD1=, FIELD2=>} TOTAL<SITE, MARKET> FARE) = 0 and FARE = Min({$<FIELD1=, FIELD2=>} TOTAL<SITE, MARKET> FARE), 'Missing'),'Missing')

       

      Thank you,

      Martha