Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table that looks something like this:
Account Amount
1511 100
3010 230
4020 110
8990 130
4010 150
If I want to summarize the amount on accounts 3000 to 3999 and 4000 to 4029, how would you write that in an expression?
Best regards
Thor
Hi Thor,
try these expressions:
1. sum(if (Account >3000 and Account < 3999, Amount))
2. sum(if (Account >4000 and Account < 4029, Amount))
May be you need ">=".
RR
Dear,
Thor.
we can do it by using set Analysis
1) summarize the amount on accounts 3000 to 3999
=sum({1<Account= {">=3000<=3999"}>}Amount)
2) summarize the amount on accounts 4000 to 4029
=sum({1<Account= {">=4000<=4029"}>}Amount)
Thanks,
Mukram.
Hi,
Try this expressions
For 3000 and 3999
=Sum({<Account= {'>=3000<=3999'}>} Amount)
For 4000 and 4029
=Sum({<Account= {'>=4000<=4029'}>} Amount)
Hope this helps you.
Regards,
Jagan.