146
Views
3
Comments
[OutSystems Data Grid] How to display the decimal value in Grid number column
outsystems-data-grid
Reactive icon
Forge asset by OutSystems
Application Type
Reactive
Service Studio Version
11.54.20 (Build 62656)

Hello All,

How to display the decimal place value in Grid number column wihtout specifing DecimalPlaces config.

I might not have fixed decimal places. It might differ based on each rows to columns.

Below grid arrange json data has the decimal value but it doesnt shows the decimal value on the UI.

I did refer to the below links but i couldn't find the possible solution to display the actual decimal places for each row and column as per the JSON values

https://www.outsystems.com/forums/discussion/87445/outsystems-data-grid-decimal-and-thousand-separator-in-number-and-currency-colu/

https://www.outsystems.com/forums/discussion/87910/outsystems-data-grid-web-why-the-decimal-point-of-the-digital-data-i-output-onl/

https://www.outsystems.com/forums/discussion/70731/outsystems-data-grid-how-to-suppress-empty-numeric-values-shown-as-zero/

Attaching the oml and excel file to upload data.

Regards,

Vinod

Uplaod File.xlsx
GridInput.oml
2022-05-19 14-01-44
Varada Rajan

Hi Vinodh,

Try Checking this:

Once after we specify the Decimal places, it would display accordingly.

Thanks 
Rajan

2022-05-19 14-01-44
Varada Rajan

you might have thought that I didn't read your question properly, but Without Specifying Decimal Places config, it would result in Integer Display instead of Decimal.

We can take a local Variable and set a maximum or dynamic value to it and use the variable in this Config. 


2023-03-08 10-32-19
Vinod Kumar R

Hi @Varada Rajan 

Thanks for your resposne.

If we use max (i.e. Price: 6.326501 Max Decimal is 5) and set the decimal place in config then it would apply for all the rows. Then my result would be as below. Whereas Price of seond row is 119.33 (2 Decimal place).

Price

6.326501

119.33000

Regards,

Vinod

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.