Summarizing a range of accounts

[#1]

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

[#2]

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

[mdmukramali]

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.

[jagan]

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.