Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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