running total #N/A problem

[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.

 

[Bob Phillips]

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)

 

[shripaldalal]

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 -

Can I send you my excel file by mail ?

Best regards,
Shripal Dalal.

 

[Bob Phillips]

No, post the details here.

--
---
HTH

Bob

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

 

[shripaldalal]

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.

 

[shripaldalal]

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.