Forum Discussion
Solved
Help to create % Measure
I have created a % measure as follows : % of Yellow = divide([No of Yellow],[Count of Category])*100-100 The result is correct when unformatted and left as general- however it is showing a min...
Hey lennox25 ,
if you want to use the format as "percentage" option, do not multiply by 100. If you want to show the result as poisitive consider using the ABS function like so:
% of Yellow = ABS(divide([No of Yellow],[Count of Category])-1)Hopefully, this provides what you are looking for.
Regards,Tom
Hey lennox25 ,
if you want to use the format as "percentage" option, do not multiply by 100. If you want to show the result as poisitive consider using the ABS function like so:
% of Yellow = ABS(divide([No of Yellow],[Count of Category])-1)Hopefully, this provides what you are looking for.
Regards,
Tom
Kudos to you 🙂 Thank you so much!!
