Ignore selections

[#1]

Hi All,

I came across an expression on the Forums which I have used to ignore certain selections:

sum({<[Year&Month]=>} [LCY Balance])   ---> Which to me says: ignore the Year&Month selection/s and sum the LCY balances.

However, I don't know how to add an IF argument to this expression, so that I can say: ignore the Year&Month selection and return the LCY balance where the currency is only EUR (for example).

Any ideas?

[#2]

I should probably mention that using a List box isn't enough - I want to be able to show a select group of different currencies in the same Straight Table, whilst keeping all currencies in a "Total" column.

[#3]

Have you tried with an if?

if(currency = 'EUR', sum({<[Year&Month]=>} [LCY Balance]), sum([LCY Balance]) )

[#4]

Thanks for the advice Federico - it made sense that it should be quite simple to amend, but I needed to re-arrange your suggestion slightly so that it looked like this:

SUM({<[Year&Month]>}

IF([LCY]='EUR', [LCY Balance]))

All in all, I just needed to place the "ignore" function between the SUM and the IF, and now it works perfectly.

Thanks for the suggestion!

[jagan]

Hi,

Check this expression

=SUM({<[Year&Month]=, [LCY]={'EUR'}>} [LCY Balance])

Regards,

Jagan.