Simple Set Analysis Question

[Qvmaster2019]

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.

[jagan]

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.

[Qvmaster2019]

Hi Jagan,

Thanks for your reply.

This will not hold true if I have other workweek.

Regards,

dnatividad

[jagan · Accepted solution]

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.

[Qvmaster2019]

Thanks Jagan!

Really appreciate your help.

Have a nice day, sir!

[jagan]

Hi,

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

Regards,

Jagan.