Calculation in a GalleryItem Label returns wrong results. (ThisItem.Fieldx * 100)

[wolfrat]

Hey Everybody - strange behavior found in a Label Calculation.

I import data from an excel File. The values are floating point values.

When I calculate the Values as shown below, I get strange results:

0 * 100 results 0 ✅

1 * 100 results 100 ✅

0.5 * 100 results 500 ❌

0.75 * 100 results 7500 ❌

Does anyone know the problem and how to solve it? Thanks a lot.

[timl · Accepted solution]

@wolfrat 

The most likely problem is that the data type of your Fortshritt column in Excel is text, rather than floating point.

I guess you're running Power Apps in a non English locale (German?), so Power Apps is recongising 0.5 as 5, and 0.75 as 75.

If this is the case, the following should provide a more accurate result.

Value(ThisItem.Fortshritt, "en") * 100

If you're running the Power Apps Studio in German, you'll need to replace the , with a ;

Value(ThisItem.Fortshritt; "en") * 100

[wolfrat]

This was it, timl. Thank you so much for a quick solution.

kind regards from the alps.