Choose Language Hide Translation Bar
Highlighted
Batista
Level II

Converting mg/dL to mg/L

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!

1 REPLY 1
Highlighted
Thierry_S
Level VI

Re: Converting mg/dL to mg/L

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
)
Thierry R. Sornasse
Article Labels

    There are no labels assigned to this post.