Decimal point formula not working

Platform discussions
,
1

I replicated the formula from this page because I’m building an invoice-structure board.

The column should show the bill amount based on the Billable hours and the Hourly Rate. However, the decimal point doesn’t work.

The current formula on the Bill column is "$"&ROUND(MULTIPLY({Billable#Hours},{Hourly Rate}),2) Can you help me, what’s wrong with my formula?

image

2

Hey Mia!

I think the trouble here is that you are adding the dollar sign in the wrong place.

Take it out and let us know if this shows the decimal to confirm that it is the culprit behind this formatting.

If it is, then we can go ahead and format the formula like so:

TEXT(ROUND(MULTIPLY({Billable#Hours},{Hourly Rate}),2),“$”)

Let me know how this goes!

3

Thanks, Charlotte!

I tried your formula, however, it resulted to an error. :pensive:

image

4

I tweaked the formula you gave me and made it "$"&TEXT(ROUND(MULTIPLY({Billable#Hours},{Hourly Rate}),2)) and this was the result.

The highlighted says $299,200. I think it should only say $29,92 at least, considering that the billable hours only tracked 24 minutes.

image

5

Try this:

CONCATENATE(“$”,(ROUND(MULTIPLY({Billable#Hours},{Hourly Rate}),2)))

image
image692×274 14.2 KB