1 Reply Latest reply on Aug 2, 2017 4:01 PM by Patrick A Van Der Hyde

    Calculate a "field calculed" based on the value of filter (Filter created with others "field calculated")

    arnaud j

      Hello,

       

      I would like to know if it's possible to calculate a filed based on the value of filter, knowing values are also field calculated.

       

      Ex :

       

       

      Indicator1Indicator2Indicator3Indicator4Indicator5
      10241

       

      If I select in filter "Indicator1" and "Indicator3" the value of the field calculated "TOTAL" = 1+2 = 3

      If I select in filter "Indicator1" and "Indicator4" and "Indicator5" the value of the filed calculated "TOTAL" = 1 + 4 + 1 = 6

       

      I think the first step should be create a parameter including these field calculated "Indicator1", ""Indicator2", "Indicator3", "Indicator4" and "indicator5".

       

      Many thanks for your help^,

       

      Arno