IIFing A Summary Report Sum

Moderators: Moderators, Tech Support

Post Reply
Posts: 48
Joined: Sat Sep 04, 2010 3:12 pm

IIFing A Summary Report Sum

Post by brentbond »

I am doing am Accounts Payable> Custom Report to show people we have paid over $600 in 2010 for 1099 purposes. I have used Detail Summary Report to "group" by vendor and "sum" an amount for them. The sum for each vendor produces and prints a variable called AMOUNT on the report. I tried to do an IIF on AMOUNT (if under $600 dont print etc) but AMOUNT is behaving like it is the last individual entry of that particular vendor not the total for that vendor (even though it prints it as the total). Can you steer me to what I am doing wrong? Thanks.

Tech Support
Tech Support
Posts: 2652
Joined: Thu May 13, 2004 8:59 am
Location: PowerChurch Software

Re: IIFing A Summary Report Sum

Post by Zorak »

Right... Create a variable to track the vendor total, rather than using that AMOUNT field in the group footer.

Under Report > Variables, click the Add button. Call it "m.total"
In the Value To Store field, enter "m.total + amount"
In the Initial Value field, enter 0
In Reset Value Based On, choose Group: Vendor

Then, back in the report body, change the "AMOUNT" field in the Group Footer to "m.total".
Under the Print When tab of the m.total field, set the Print When to "m.total>=600"

Post Reply