conditionally change data type.

[onkarkulkarni]

Hi All,

I have a requirement to show specific product type sales in % values , rest in actual figures.

e.g   For B & D Prod Type , I will get 30 and 40 respectively from source, I want to show it as 30 % and 40 %

Prod_Type	sales
A	100
B	30%
C	50
D	40%
E	90

[bhargav_bhat · Accepted solution]

Hi Onkar,

Change number formatting in measure to Measure Expression as shown below

Now write this is expression

if (PROD_TYPE='B' or PROD_TYPE='D',num( Sum(Sales)/100,'##.0%'),sum(Sales))

Regards,

Bhargav

[onkarkulkarni]

Thanks a lot Bhargav for swift reply