Using picklist as part of the formula


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!


I changed to %[Patient copay] still error

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

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. :honey_pot: :honeybee:




A post was split to a new topic: Calculating time in months

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.