6 Replies Latest reply: May 22, 2017 7:18 AM by Sunny Talwar

# Problem with aggr() or only()

Hi every body,

My goal is to calculate the total cost only with bank where i have an interaction

I don't arrive to fix this issue with the function aggr

 Bank Interaction per month Bank1 15 Bank2 12 Bank3 5 Bank4 4 Bank5 0 Bank6 0 Bank7 0

 Bank Cost Bank1 10000 Bank2 10000 Bank3 10000 Bank4 10000 Bank5 10000 Bank6 10000 Bank7 10000

Total cost expected is 40000

• ###### Re: Problem with aggr() or only()

Try something like:

Sum( {<[Interaction per month]={'>0'}>} Cost)

• ###### Re: Problem with aggr() or only()

that doesn't work because Interaction per month is a formula:
=count(interaction)

The set analysis doesn't work in this case

eric

• ###### Re: Problem with aggr() or only()

Then Sunny's suggestion below should work.

• ###### Re: Problem with aggr() or only()

Do you have just Bank as dimension or do you have Bank and Month as dimension? If you just have Bank as dimension, then you can try this

Sum({<Bank = {"=Count(Interaction) > 0"}>} Cost)

If you have Bank and Month as dimension, then may be create a new field in the script like this

Month,

Bank&Month as Key

....

FROM ....;

and then this

Sum({<Key = {"=Count(Interaction) > 0"}>} Cost)

• ###### Re: Problem with aggr() or only()

Or may be this if you don't have a pre-aggregated Interaction per month column

Sum({<Bank = {"=Count(Interaction) > 0"}>} Cost)

• ###### Re: Problem with aggr() or only()

thank sunny

works perfectly

regards