Method Community

 I can't find any relevant posts or webinars on calculated fields. I've been struggling with the syntax.

Some of the items in my quotation are not chargeable, but I want them included on the estimate. Instead of $0.00 I want the report to display 'Included'.

I've been playing with this for over an hour. The expression I have is:

if([Estimate.EstimateLine.Estimate.TotalAmount] is null,'included',[Estimate.EstimateLine.Estimate.TotalAmount])

It doesn't work. Anyone have any ideas?

Hi SpaScapes,

Take a look at the Print Before scripts on the Qty and Cost fields on the Estimate (Custom) template. This should give you a better idea of what you need to do.

-Michael

Thanks for the help, I finally figured it out!!!

If anyone else wants to do this, enter this script into a Before Print script window:

If xrItemAmount.Text = "$0.00" Then xrItemAmount.Text = "included"

Keep in mind, this example is for the ItemAmount field. Also, the script will not work if you actually put it into the ItemAmount field script itself. It has to be in another field. It seems that fields won't edit themselves, but will edit others.