You need to sign in to do that
Don't have an account?
Erin Evarts 13
Exclude picklist type from formula when calculating commission
I am trying to exclude an Opportunity Type picklist value when calculating a commission.
My formula is:
IF (NOT(ISPICKVAL(Type, 'Flooring')))
Total_Amount_Invoiced__c >= 5000.00,
500.00,
0.00)
If the Total Amount Invoiced >= 5000.00 for all Opportunity types EXCEPT 'Flooring', return 500.00, if not >=5000.00, return 0.00.
IF (
Total_Amount_Invoiced__c >= 5000.00,
500.00,
0.00)
works but need to exclude 'Flooring' and I am stuck.
My formula is:
IF (NOT(ISPICKVAL(Type, 'Flooring')))
Total_Amount_Invoiced__c >= 5000.00,
500.00,
0.00)
If the Total Amount Invoiced >= 5000.00 for all Opportunity types EXCEPT 'Flooring', return 500.00, if not >=5000.00, return 0.00.
IF (
Total_Amount_Invoiced__c >= 5000.00,
500.00,
0.00)
works but need to exclude 'Flooring' and I am stuck.
There was a extra brace after flooring,Now removed that try this code :-
IF (AND(NOT(ISPICKVAL(Type, 'Flooring')),
Total_Amount_Invoiced__c >= 5000.00),
500.00,
0.00)
Thanks
Anil.B
All Answers
Try this formula:-
IF (AND(NOT(ISPICKVAL(Type, 'Flooring'))),
Total_Amount_Invoiced__c >= 5000.00),
500.00,
0.00)
Thanks
Anil.B
Thank you for responding so quickly .I received Error: Syntax error. Extra ','.
I don't see where to remove , from this:
IF (AND(NOT(ISPICKVAL(Type, 'Flooring'))),
Total_Amount_Invoiced__c >= 5000.00),
500.00,
0.00)
There was a extra brace after flooring,Now removed that try this code :-
IF (AND(NOT(ISPICKVAL(Type, 'Flooring')),
Total_Amount_Invoiced__c >= 5000.00),
500.00,
0.00)
Thanks
Anil.B