Converting mg/dL to mg/L

Batista

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!

Thierry_S

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
)