Varible

[upaliwije]

I have created the following variable

ENetProfit   (Sum({<[NOTE]={100},DEPT={'BRAN'},MONM={'MOTOR'},BRANCH= >}[AMOUNT])

when I applied it under a pivot table $(ENetProfit)    it is working fine

but when I applied it in a text box it is not working.  =num($(ENetProfit))  Pls help

[nirav_bhimani · Accepted solution]

Hi,

You should remove $ then try the same.

If you define variable & assign the value with equal to sign then no need of $ to evaluate that variable, Kindly find the attached file to get clear picture.

Thanks & Regards,

Nirav Bhimani