Unwanted Decimals Displaying on DetailScreen

Like (0) Share

Report

Posted on 15 Jan 2025 18:29:34 by Sniderj1

I have 2 SP lists where one references another with unique value. The list pulls in several fields so I don't have to type them in every time. One of the values, PPI, is set to be a number with 0 decimal places in my list settings. On the Gallery, I used Value(ThisItem.PPI.Value) and it took the decimals away. However, on the DetailScreen, when I use the same formula, nothing happens. I've also tried

Text(ThisItem.'TOTAL TARGET HECTARES'; "#.#")

and 
Round(ThisItem.'TOTAL TARGET HECTARES', 1)
formulas, to no avail. Any ideas? TIA!

Categories:

Using Apps Using Formulas

General Questions

All responses (1)

Answers (0)

SaiRT14 1,961 Super User 2025 Season 1 on 15 Jan 2025 at 19:01:26

Like (0)

Report

Unwanted Decimals Displaying on DetailScreen

Hi

Ensure that the PPI column is listed as a numeric field - Round(Value(ThisItem.PPI), 0)

let me know if you still have issue.

thanks