11 Replies Latest reply on Sep 16, 2018 1:18 PM by Deepak Rai

    Calculated Field based on Dimension Criteria

    Mila T

      Hello,

      Quick question. I'll try to explain it without TW.

      I have created this formula first: IF [Method]="Scn" THEN COUNTD([BF SN]) END --- it says Cannot mix aggregate  and non-aggregate comparisons

      Then, I put ATTR in front of [Method] : IF ATTR [Method]="Scn" THEN COUNTD([BF SN]) END - it works but only if I have Dimension in Rows/Columns. If I remove this Dimension from sheet it returns blank.

       

      So, I need this formula to return me a value no matter if I have this Dimension ("Methos") on Sheet or no.

       

      Is it possible?

       

      Thanks!