running total #N/A problem

  • Thread starter Thread starter shripaldalal
  • Start date Start date
S

shripaldalal

hi,

i am trying to make a stock register.

I have the following row fields:

Product, transaction_date

and following data fields:

receipt, issue, balance (balance is a calculated field whose formula
is receipt - issue and shown as running total with base of
transaction_date)

it is running perfectly allright till i add one more row field called
transaction_no after transaction_date.

the running total column gives me a #N/A. I am trying to make a stock
register that shows the product, dates and transaction no's of each
product and five a running total at the end of every transaction.

if it is not possible can i use VBA to do something ?

best regards,
shripal dalal.
 
What formula is giving the #N/A?

Should be possible with a simple SUMPRODUCT, but the data layout and an
example would help as I don't understan your differentiae between row and
data fields.



--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
What formula is giving the #N/A?

Should be possible with a simple SUMPRODUCT, but the data layout and an
example would help as I don't understan your differentiae between row and
data fields.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)















- Show quoted text -
Click to expand...

Can I send you my excel file by mail ?

Best regards,
Shripal Dalal.
 
No, post the details here.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Hi Bob,

There are three row fields,

product, transaction date, transaction no

and three data (sum) fields, receipt, issue and balance which is a
calculated field shown as running balance with base field of
transaction date (receipt - issue)

product: hydrochloric acid
date: 4/1/2007
transaction: opnbal

40 0 40
date: 4/2/2007
transaction: inv/1
0 20 20
date: 4/3/2007
transaction: purchase/1
10 0 30

product: sulphuric acid
date: 4/1/2007
transaction: opnbal

10 0 10
date: 4/1/2007
transaction: purchase/1
15 0 25

so running balance (the last data field) has to have base field of
transaction date, but instead of showing me the running balance values
in the above way.........excel shows me #N/A

thanks......

regards,
shripal dalal.
 
bob,

i am sorry i forgot to write the field names in the last message, the
first three row fields are: product, transaction date, and transaction
number

and the numbers are qty rec, qty iss and balance (which is a
calculated field running total with base field of transaction date)

I just dont know how to do the formatting in google. it's a nightmare
to format plain text messages.

regards,
shripal.
 
Back
Top