Report trouble, HELP!

[Zcast]

OK, I'm working on putting together a subsummary report for my mileage records and what taxes I have to pay for the mileage I drive. I have 99.9% of the report done , but I am having trouble with ONE field. I am trying to subtract one summary field from another to get a result, but all it shows is 0. I have attached a demo version for reference if someone could please tell me what I'm doing wrong, (and/or) better way to put this together.

Thank you,

Zcast

demo.zip

[Beth Bennett]

Hi - took a look at the sample file. You just need to use the GetSummary() function when doing math on summary fields. So the definition of NET_Taxable Gals should be:

GetSummary ( SUMMARY_taxable_gals ; State ) - GetSummary ( SUMMARY_gals_purchased ; State )

That tells FileMaker to look at the result in the subsummary. Otherwise, it will ignore the fact that the report is summarized and just operate on all records.

HTH,

Beth

[Zcast]

Thank you very much Beth, I'm still pretty new to FM, and I have tons of reference materials, but I learn much, much more from people such as yourself. Thanks again.

[Zcast]

OK, Beth bennett helped me out with this file last night, but now I have ran into another snag. I have two fields, tax rate, and tax surcharge rate for each record...here's the problem...some of he rates show up in my report...while others don't???

Can someone please take a look and tell me what's causing this to happen?? This is the last piece to my puzzle of a report.

Thanks in advance

demo.zip

[Lee Smith]

I merged your two topices, Please do not double post your question.

[Zcast]

Sorry Lee, same file different question..but I understand what you mean. Thanks.

[LaRetta]

Hi zcast,

In your State table, CO and IN have spaces after the state code while the others are fine. And you don't have Tax Paid Gals on Co, IL and IN because they have no Gals Purchased and that is required for that summary. If I'm missing the point, let us know and I'll look again. :wink2: