AnsweredAssumed Answered

Calculation field with If( ) statement

Question asked by enstorms on Mar 15, 2018
Latest reply on Mar 15, 2018 by enstorms

Can't find an answer to this problem.  Problem something simple but can't figure it out.  Have a price extended field as a calculation from Price, Quantity, and Percent.


If ( not IsEmpty ( percent ) ;

   price  * percent  * quantity / 100 ;        >>  This works fine

   price * quantity )         >>  This works fine


The problem is if I delete the value in the Percent field, Price Extended shows zero.  Change quantity or price field, still zero.  Add a Percent value back in and figures correctly.  What am I missing?