2 Replies Latest reply: Aug 21, 2016 9:19 AM by Sunny Talwar RSS

    Sum of a field for a specific value in a variable

    Bijoy B

      Sum({<[Category] = {$(Graph1-Group-Value)}>}Budget)

       

           I want to find the sum of Budget, when Category matches a value specified in a variable, where category is another field in the dataset with Budget.

       

      Here '$(Graph1-Group-Value)' is defined as below

       

                  if($(Graph1-Group1) = 'CML & Synd. Loans - Avg','CML & Synd. Loans - Avg','No Value')

       

      With the above script, the value is not captured