1 Reply Latest reply on Jul 25, 2018 10:17 PM by Zhouyi Zhang

    Parameter, Calculated Field and In/Out Scope

    Nina Royce

      I need some help here. I have created an input parameter (Group PM) and below is the formula to create a new field with in or out of scope indication. and it works if I have those values in the table

       

      if ABS(SUM([Fair value]))> [Group PM] then 'Y'

      ELSE 'N'

      END

       

      tableau Q.PNG

       

      However, when I remove the middle field and want to show totals by Y and N only, it just sums up all values regardless Y or N and I am not even able to apply a filter, as it only shows Y?

      Not sure how to explain this. Can someone help me please?

       

      tabl q2.PNG