Converting mg/dL to mg/L

Batista — Fri, 05 Jul 2019 17:36:36 GMT

HI!!!

I have a column and I have some of the measures are in mg/dL the other half in mg/L . How is the best way to convert them?

Thank you in advance!

Re: Converting mg/dL to mg/L

Thierry_S — Fri, 05 Jul 2019 18:34:49 GMT

If you know the exact number of rows with data in mg/dL vs. mg/L, you can create a new column with an "If" statement checking for the "Row()" to be smaller or equal to the threshold row.
If( Row() <= 50,
:DATA * 10,
:DATA
)

If you have a reference column with the Units, the same simple "If" statement can be used as follows

If( UNIT <= "mg/dL",
:DATA * 10,
:DATA
)

topic Converting mg/dL to mg/L in Discussions

Converting mg/dL to mg/L

Re: Converting mg/dL to mg/L