I’m having an odd issue. Most of the time, but not all of the time, the Total + Tax calculated field shows no value if the Free Wheelin’ rate plan is selected on the calculator found here: http://carshare.org/trip-cost-calculator/ The really odd thing about this is that the Total + Tax is not directly dependent on the Rate Plan. Total + Tax is dependent on Subtotal and Tax Jurisdiction. Subtotal is dependent on the Rate Plan, Hours, and Time. Why would selecting Free Wheelin’ Rate Plan cause the Total + Tax not to display sometimes and work fine others?
The code in the Subtotal Set Equation box is exactly as follows:
if (fieldname5==”Free Wheelin”)
if (floor((fieldname3-days*24)/(39/4.5))==0) hours=fieldname3%24;
if (fieldname4<=50) subtotal=fieldname4*.33+days*39+hours*4.50;
if (fieldname5==”Peace of Mind”)
if (floor((fieldname3-days*24)/(49/6.95))==0) hours=fieldname3%24;
if (fieldname4<=50) subtotal=fieldname4*.38+days*49+hours*6.95;
The code in the Total + Tax Equation box is exactly as follows:
Thank you for your help!
- The topic ‘Dependent calculated field does not always show value’ is closed to new replies.