AnsweredAssumed Answered

Truncate Issue

Question asked by Matty_1 on Aug 2, 2012
Latest reply on Aug 3, 2012 by philmodjunk

Title

Truncate Issue

Post

Hello,

 

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)

Thank you!

Outcomes