Changing the format type in a expression

[Adam_Grunys]

Hello, I have a workflow the is calculating the percent between two Price type columns. The calculation works but shows as Price as the format and not as percentage. How can I changes this to a percentage in the expression?

*<<(sum(Select(Monthly Job Cost Work Orders[WorkOrderGrossMargin], TRUE))/sum(Select(Monthly Job Cost Work Orders[WorkOrderEstTotal], TRUE)))100>>

Thanks

[Aleksi]

Try to wrap the whole formula inside of NUMBER() or DECIMAL() expression.

[Adam_Grunys]

Aleksi:

DECIMAL

Thanks, “Decimal” did removed the $ sign. Should concatenate a % to front or is there another method?

[Aleksi · Accepted solution]

CONCATENATE() is not needed, just %<<SUM(…)*100>> is enough.

[Adam_Grunys]

Adam_Grunys:

DECIMAL

Right… Thanks so much for the quick support!!!

[Aleksi]

You’re welcome