AnsweredAssumed Answered

Issue creating IfElse formula

Question asked by Robert McAnally on Oct 31, 2019
Latest reply on Oct 31, 2019 by Robert McAnally

I am rather new to Sugar so need a bit of help with this IfElse:

 

I have a calculated field on Quote module that I want to be the Unit Price of a Quoted Line Item if the Line Item is of the value of X; otherwise, the value will be "$0.00" (but no currency symbol as the field's type is Currency).

 

My formula:

ifElse(equal(related($revenuelineitems,"name","X."),related($revenuelineitems,"discount_price"),"0.00"))

 

Error:

Invalid Formula
Cannot read property 'returnType' of undefined

Outcomes