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

# 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.

• ###### Re: Set analysis use value of another expression

hi did u try

Sum({1<AccountNo = {">=100000<=199999"}>}TOTAL Amount)