Jump to content
Sign in to follow this  

Gatting a Profit in Report.

Recommended Posts


I am new on Filemaker Pro. I was getting a error. Here is the scenario i wanted to generate a Daily report using 2 tables.

Product, Sale and Sale Detail. As table name shows it stores data regarding products and it purchase and Sell prices. Sale table stores data about sale and sale detail about Products inline.

The Report is daily basis it show how much of a single product soled in a day. it unit price and total amount of the sale. I just wanted to add another field of Profit. Which will be calculated as follows

Total Sale amount - Total Qty Sold * Product unit Price.

This is how it is written in calculation field"s_Sum_Total - Product_Sale Line::ProductPurchasePrice * qty_total"

But the result it show are wrong.

For Reference i have uploaded the File. The Report name in the file is "Daily Report Profit"


File user name:Admin

Pass :19508642i

Kindly help me Urgent


Share this post

Link to post
Share on other sites

Ok, I figured out how to get profit. But the Final does not get sorted my date after putting it in First Sub summery part and Also In Grand Total summery? Kindly help on this.

Share this post

Link to post
Share on other sites

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
Sign in to follow this  


Important Information

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