Using picklist as part of the formula

[Juice]

@aj

Hi Aj and community,

I change copay to a picklist

And I remain the same formula to calculate patient pay

But it shows #value

So my question is should I change anything if I want to use the % or number from picklist as part of the formula??

Does the question make sense?

Thank you!

[Juice]

I changed to %[Patient copay] still error

[Alyssa]

Hi @Juice , thanks for the screenshots! I'm happy to help.

Since your variable $[Patient Copay] is an entire row or rowlink, you'll need to also specify the column in the table that has the desired value.

Meaning in the formula, this piece would look like:
($[Patient Copay][Name of column with desired value])

Let us know if that helps. If you're still getting an error, we recommend splitting up the formula to ensure that all other variables are available on the screen.

[Juice]

Perfect!