AnsweredAssumed Answered

Help with conditional calculation

Question asked by uaykylie on May 13, 2015
Latest reply on May 13, 2015 by uaykylie


Help with conditional calculation


I am trying to calculate based on a condition.  The fields are Registration Total ($), Registration Prepaid (Y/N), Sub-Total of Sales ($).  I want the Sales Total to be equal to Registration Total + Sub-Total if the response in the Registration Prepaid field is No. If the response is Yes in Registration Prepaid I want the Sales Total and Sub-Total to be the same. I feel like I am halfway there but it's still not right.  Here is what I currently have:


If ( not Registration_Prepaid ; Registration_Total + Silent Auction Items::Total purchase ; Silent Auction Items::Total purchase )