I have a text calculation field and I would like to have it display "CAD - $15487.98".
In some cases that total only has one or no decimal numbers, I tried adding zeros in quotations to the end of the total and using the truncate function and it removes all the zeros. Can someone please give another suggestion?
This is the formula I thought would work but doesn't:
"CAD - $" & Truncate((Total_price & "00");2)