Jump to content
Sign in to follow this  
gullfounder

Gatting a Profit in Report.

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

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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