cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
Batista
Batista
Level II

Converting mg/dL to mg/L

Jul 5, 2019 01:36 PM (2667 views)

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!

0 Kudos
1 REPLY 1
Thierry_S
Super User Thierry_S
Super User

Re: Converting mg/dL to mg/L

Jul 5, 2019 02:34 PM (2661 views)  |  Posted in reply to message from Batista 07-05-2019
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