Missing zero from decimal

(0) Share

Report

Posted on by rosscortb

196

Hello

I have a table displaying share point data, for the price column using the formula of

Value(Text(ThisItem.'Total Price',"£#.##0.00"))

It not showing the second decimal if its a zero. It does in the sharepoint list.

Any ideas why?

Thanks

Ross

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

It's because you are formatting this as a Value, which does not need trailing zeroes and has no setting for how many decimals to display.

I would suggest to keep them as Text until you need to convert them for something else.

Text(ThisItem.'Total Price'),"£#.#0")

Was this reply helpful? Yes No
rosscortb 196 on at

Like (0)

Report

@iAm_ManCat
Thanks. I took the bracket out as was showing as an error.
Text(ThisItem.'Total Price',"£#.#0")

Now shows as,

Thanks
Ross

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

Can you give some more context around this, my example I created only showed the two digits as specified by the Text value

are there labels inside that column and what are their Default values

Was this reply helpful? Yes No
rosscortb 196 on at

Like (0)

Report

It takes the price from this is sharepoint column,

In the list it shows,

But the PowerApps table is not displaying the zero if there is a zero as the second decimal.

You can see the 16.75 but in the row above there is a zero after the 8 so it should read, 90.80.

Thanks
Ross

Was this reply helpful? Yes No
Verified answer

iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report
Ah, so its a calculated column not a text value

We could probably get away with using the following:

Text(ThisItem.'Total Price',"£#.00")

If that doesn't work then you could split it and rejoin it as text, but let's try the above first

Otherwise we could go the spli

Was this reply helpful? Yes No
rosscortb 196 on at

Like (1)

Report

@iAm_ManCat Ah that's it. So weird as seems so simple. Sure I probably tired about 30 different flavors of that formula.
Thanks for your help.

Was this reply helpful? Yes No