You need to sign in to do that
Don't have an account?
babacandoit
Text-Formula
Hi All,
I am creating a custom Formula-Text-field 'Level of Disount'.
depending on Disount-Range, Level of Disount must be changed,
Here goes the My Formula,
//--->Formula starts here
IF((Discount_Percentage__c >=5 || Discount_Percentage__c<=10) , 'Level-1',
IF((Discount_Percentage__c >=10 || Discount_Percentage__c<=20), 'Level-2',
IF((Discount_Percentage__c >=20 || Discount_Percentage__c<=30), 'Level-3',
IF((Discount_Percentage__c >=30 || Discount_Percentage__c<=40), 'Level-4',
'No Disount'))))
//---Formula End here <---
For all the Discount_Percentage__c it is showing Only Level-1 :(
Thanks in Advance.
Cheers
Baba
I am creating a custom Formula-Text-field 'Level of Disount'.
depending on Disount-Range, Level of Disount must be changed,
Here goes the My Formula,
//--->Formula starts here
IF((Discount_Percentage__c >=5 || Discount_Percentage__c<=10) , 'Level-1',
IF((Discount_Percentage__c >=10 || Discount_Percentage__c<=20), 'Level-2',
IF((Discount_Percentage__c >=20 || Discount_Percentage__c<=30), 'Level-3',
IF((Discount_Percentage__c >=30 || Discount_Percentage__c<=40), 'Level-4',
'No Disount'))))
//---Formula End here <---
For all the Discount_Percentage__c it is showing Only Level-1 :(
Thanks in Advance.
Cheers
Baba
All Answers
Thanks, Thanks in Ton :)
Cheers..
Baba