I have a report that contains formulas for individual criteria and those items work. When I take one of those formulas and subtract if from my other total it is not pulling the correct amount. Any Ideas?
Here is the formula I am having issues with:
if {fa_master.fa_disposal_date} > DateTime (2013, 06, 30, 00, 00, 00) and
{fa_master.fa_acquire_date} < DateTime (2013, 07, 01, 00, 00, 00) then {fa_master.fa_purchase_cost}
This works by itself and is named disposals but when I put it into the following formula it will not work and I am not sure what it is pulling in wrong:
{fa_master.fa_purchase_cost}+{@PURCHASES}-{@disposals}
The totals are as follows
1,548,194.82+208,721.00-144,752.00 The report is saying this is 36,542.52

I have it as a group footer all 3 amounts are in the group (purchase cost, purchases, and disposals) and they are all showing correct. In the other formula showing where I add purchases and subtract disposals this is also a group footer but not calculating correct.

evaluates once per row and returns a value for each row that does not include prior or next rows. If you want to know a toal for the group that all the rows are a part of you need to sum it at the group level

Edited by DBlank - 10 Sep 2014 at 11:54am

you cannot really sum a sum.