Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Hi Jagan,
Thanks for your reply.
This will not hold true if I have other workweek.
Regards,
dnatividad
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.
Thanks Jagan!
Really appreciate your help.
Have a nice day, sir!
Hi,
Mark this Post as Answered, if it fixes your problem.
Regards,
Jagan.