AnsweredAssumed Answered

How to exclude customer groups in a calculated field?

Question asked by Jaqueline Bargmann on Oct 11, 2018

Hello,

 

 

I've built a calculated field in the opportunities module  (sugar 8.0 Professional) and it works fine. 

 

ifElse(greaterThan($amount,10000),divide($amount,3),0)

 

--> installment payments should be divided by 3. if they exceed 10,000€.

 

However, this should not be done for certain customer groups. After googling for while, I couldn't find a function which excludes groups or the functions I've tried didn't work.

 

This is the last attempt I've made: 

 

ifElse(greaterThan($amount,10000),divide($amount,3),

and(

isInList($icc_account_type_dom,createList("chambers","churches"))))

 

The function itself works but it does not bring the expected results. It is still doing the calculations in all customer groups. 

 

Thank you in advance for your help!

Outcomes