You need to sign in to do that
Don't have an account?
Shruti Vaishya 4
How to use picklist value in formula?
I have a picklist with values : 5%, 10%, 15%
And I want to use it in the formula field in percent format only like 5/100.
So please suggest what syntax should I write?
And I want to use it in the formula field in percent format only like 5/100.
So please suggest what syntax should I write?
Please try the below formula:
One more suggestion is you can change the API Name of the picklist values for ex: Label is 5% and API Name is 5. Then no formula is required to convert this values directly you can refer in formula.
Thanks,
Maharajan.C