User Community
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: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
Batista
Batista
Level II

Converting mg/dL to mg/L

Jul 5, 2019 01:36 PM (4148 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 (4142 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

Recommended Articles