Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
In the dimension I have a value list ('WP','LY','LLY','LLLY','WP vs LY','LY vs LLY','LLY vs LLLY'). In the expression I'm using pick function based on derived expression as show below. I want to do the subtraction of WP header and LY header. Is it possible?
=Pick(Match($(vReportHeader),'WP','LY','LLY','LLLY','WP vs LY','LY vs LLY','LLY vs LLLY'),
([ITP (Total)]-[AUR (FP/POS)])/[ITP (Total)],
([ITP (Total)]-[AUR (FP/POS)])/[ITP (Total)],
([ITP (Total)]-[AUR (FP/POS)])/[ITP (Total)],
([ITP (Total)]-[AUR (FP/POS)])/[ITP (Total)],
([ITP (Total)])),
([ITP (Total)]-[AUR (FP/POS)]),
([ITP (Total)]-[AUR (FP/POS)]))
Are you getting any issue when you use this function? What expression are you using in your vReportHeader?
May be use quotes around the variable like?
Match( '$(vReportHeader)', ....
Where you want subtraction need?
May be this?
=Pick(Match($(vReportHeader),'WP','LY','LLY','LLLY','WP vs LY','LY vs LLY','LLY vs LLLY', ValueList('WP - LY')),
([ITP (Total)]-[AUR (FP/POS)])/[ITP (Total)],
([ITP (Total)]-[AUR (FP/POS)])/[ITP (Total)],
([ITP (Total)]-[AUR (FP/POS)])/[ITP (Total)],
([ITP (Total)]-[AUR (FP/POS)])/[ITP (Total)],
([ITP (Total)]),
([ITP (Total)]-[AUR (FP/POS)]),
([ITP (Total)]-[AUR (FP/POS)]),
(([ITP (Total)]-[AUR (FP/POS)])/[ITP (Total)] - ([ITP (Total)]-[AUR (FP/POS)])/[ITP (Total)]),
)