Thanks for your help. I was partially successful
I made a formula @CashNet:
whilereadingrecords
if {tsCashier_Deductions.code} = "2013" or {tsCashier_Deductions.code} = "19" then
formula = {tsCashier_Deductions.AMOUNT}
end if
Then I inserted a subtotal and added @Cash to...
I wnat to create a formula that extracts 1 record for a group of data in a drill down so I can create a percent
In the Sample Data below I know if the "code" field data is 789 then that is "Net Sales" and I need value from the "Amount" field:
Example:
Sue 1/1/2003...
The main part of the report comes from tsUsageVariance and tsInventory. This returns several records for a date then "starts over" on the next business date.
For the same date I need to find 2013 in the code field of tsfinancial and when I find it "capture" the...
I have a drill down report that returns several records from 2 tables. In the group footer after each section I want to query another table for one record for the same date.
Neither
IF {tsFinancial.CODE} = "2013" then {tsFinancial.AMOUNT}
OR
IF {tsFinancial.CODE} = "2013"...
Thanks for the response. In the drill down report imight have the following data:
date begin in rec end
1/1/2001 100 5 0 100
1/2/2001 201 0 0 201
1/3/2001 125 0 2 125
What i need to display is
1/2/2001 100 0 0 201
1/3/2001 201 0 2 125
I cannot figure out...
I want to create a report where the data from one field is from the previous days data and the rest of the fields from the table are for the curent day, in a drill down report
I.e. Begin + received + Transfers - end = usage
Yesterday + current+current - current = formula
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.