Pick function.

[vnachiap]

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)]))

[vishsaggi]

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)', ....

[Anil_Babu_Samineni]

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)]),

)