Changing the format type in a expression

expressions
(Adam Grunys) #1

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>>

image

Thanks

(Aleksi Alkio) #2

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

(Adam Grunys) #3

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

(Aleksi Alkio) #4

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

1 Like
(Adam Grunys) #5

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

1 Like
(Aleksi Alkio) #6

You’re welcome