Select to view content in your preferred language

Simple calculation or so I think.

186
2
09-11-2024 06:34 AM
jeffhyderBRVA
Emerging Contributor

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?

0 Kudos
2 Replies
MobiusSnake
MVP Regular Contributor

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
MVP Esteemed Contributor

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

0 Kudos