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
Solved! Go to Solution.
CONCATENATE() is not needed, just %<<SUM(…)*100>> is enough.
Try to wrap the whole formula inside of NUMBER() or DECIMAL() expression.
Thanks, “Decimal” did removed the $ sign. Should concatenate a % to front or is there another method?
CONCATENATE() is not needed, just %<<SUM(…)*100>> is enough.
Right… Thanks so much for the quick support!!!
You’re welcome
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |