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