Converting mg/dL to mg/LHI!!!
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/LIf 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
)
