Jump to content

Gatting a Profit in Report.


gullfounder

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

Recommended Posts

Hi,

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"

https://rapidshare.com/files/953941978/Project_Filemaker_TuckShop(26-8-2012)Copy.fp7

File user name:Admin

Pass :19508642i

Kindly help me Urgent

Thanks

Link to comment
Share on other sites

This topic is 4225 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
×
×
  • Create New...

Important Information

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