3 Replies Latest reply: Dec 19, 2012 7:07 AM by tine theunis RSS

    Set analysis use value of another expression

      Hello,

       

      I have a table looking like this:

       

      AccountNoFormulaAmount
      1">=100000<=199999"To be calculated (700)
      100000100
      110000100
      120000500
      2">=200000<=299999"To be calculated (550)
      200000200
      200009300
      21000050

       

      I want to calculate the amount for headers 1 and 2 using set analysis. I've made the expression 'Formula' which contains a formula I can use to filter the correct account numbers for the total.

       

      If I use      Sum({$<AccountNo = {">=100000<=199999"}>}TOTAL Amount)      I get a correct result for AccountNo 1. But then I have to make a formula for every total account there is..

      Is there any way I could use the value of another expression in a set analysis formula to calculate another expression?

      I have tried things like Sum({$<AccountNo = Formula>}TOTAL Amount) but that didn't work.