ShowAll Questionssorted byDate Posted
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.

Best Answer chosen by Erin Evarts 13
@anilbathula@
Hi Erin,

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

@anilbathula@
Hi Erin,

Try this formula:-

IF (AND(NOT(ISPICKVAL(Type, 'Flooring'))),
Total_Amount_Invoiced__c >= 5000.00),
500.00,
0.00)

Thanks
Anil.B
Erin Evarts 13
Hi Anil,

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)
@anilbathula@
Hi Erin,

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
This was selected as the best answer