Simple calculation or so I think.

[jeffhyderBRVA]

I am pulling data from openweather api and I am trying to convert the pressure hPa into mercury inches so I would take the hPa and multiply it by .02953 to convert it to mercury inches. Attached is the rows from my xls forms and it is pulling the hPa correctly but returning a 0 for my second column for barocalc. What am I doing wrong?

[MobiusSnake]

I tested this on a similar form of my own.  Oddly it looks like you need a leading zero in your factor, if you change it to 0.02953 instead of .02953 it should work.

[DougBrowning]

Yep I have seen this a number of times.  Need the leading 0 for sure.