2 decimal places in view

[haplc]

Hello All,

Please see screen shot attached of my app:_ I have to show 1 inch = 2.54 cms. I have used folliwning code: 

IFS(
([Unit] = "Centimeter"), [RawNumber],
([Unit] = "Meter"), ([RawNumber]*100),
([Unit] = "Kilometer"), ([RawNumber]*100000),
([Unit] = "Inch"), ([RawNumber]*2,54),
([Unit] = "Foot"), ([RawNumber]*30,48),
([Unit] = "Yard"), ([RawNumber]*91,44),
([Unit] = "Mile"), ([RawNumber]*160900),
([Unit] = "Nautical Mile"), ([RawNumber]*185200),

)

Issue is I am seeing cenitmater = 2 and NOT 2.54

Please tell me how to manage this

Thanks

[WillowMobileSys · Accepted solution]

It seems like it is a locale discrepancy.  I think AppSheet is ignoring the part after the comma.  Trying changing the comma to a period and see of the value shows up correctly.  Then you'll know.

Once you have verified that then you will want to make sure you have all locations set to the correct "locale"....AppSheet, Browser and datasource - this includes on each table configuration in AppSheet.  

[haplc]

Thanks a lot. I change ,with . and it is working