Jump to content

need some help in subsummary report


omega
 Share

This topic is 5768 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi All,

I am new to FileMaker and I am trying to create a subsummary report for an existing database. I have to print invoice entries group by customer, object class. A customer can have many object classes. So the report should look like

Customer 1

Object Class1

invoice records

Object Class2

invoice records

Customer2

Object Class1 (for this customer)

and so on...

Now I have to compute total amount of purchase for every object class type for a customer and then apply some discount on them. For the total amount and discount, I have created two summary fields. Now I should display the net amount ( total amount - discount). I dont know how to implement this. Should I create a new field to store the difference between the two summary fields. In that case, what will be this field type. If it is not a summary field type, then can I place it in the sub-summary part of the layout.

Any help is greatly appreciated.

Thanks.

Link to comment
Share on other sites

This topic is 5768 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.