5 Replies Latest reply: Feb 10, 2012 1:32 AM by jagan mohan rao appala

# Simple Set Analysis Question

I am trying to run simple set analysis with two dimensions (Metric Name and Workweek). The logic is that :

If the Metric Name is "TOTAL Invoice Amount Paid", it should sum up all the total of specific 3 metrics but for some reason, it can't.

Please see attached.

• ###### Simple Set Analysis Question

Hi,

Try this expression it works.

=if([Metric Name]='TOTAL Invoice Amount Paid',

sum({<[Metric Name]={'Amount Invoice #1 - Paid (\$K)','Sum of Invoice #2 - Paid (\$K)','Invoice #3 - Paid (\$K)'}>} TOTAL [TotalValue])+ 1,

Sum([TotalValue]))

Hope this helps you.

Regards,

Jagan.

• ###### Re: Simple Set Analysis Question

Hi Jagan,

Thanks for your reply.

This will not hold true if I have other workweek.

Regards,

dnatividad

• ###### Simple Set Analysis Question

Hi,

Try this,

=if([Metric Name]='TOTAL Invoice Amount Paid',

sum({<[Metric Name]={'Amount Invoice #1 - Paid (\$K)','Sum of Invoice #2 - Paid (\$K)','Invoice #3 - Paid (\$K)'}>} TOTAL<Summary_Week> [TotalValue])+ 1,

Sum([TotalValue]))

Regards,

Jagan.

• ###### Re: Simple Set Analysis Question

Thanks Jagan!

Really appreciate your help.

Have a nice day, sir!

• ###### Simple Set Analysis Question

Hi,

Mark this Post as Answered, if it fixes your problem.

Regards,

Jagan.