Using view totals in view

Hi, I was wondering if it was possible to do some simple calculations with existing view totals.

I am asking this because I have a view, with 2 forms, and each have a column that the other has no value for, then i would like to do a calculation.

I.e. Form A has values for Column A, Form B has values for Column B

Can i do something liek Column C = A/B. So far I am having no luck because the calculation in Notes is handled before the totals are done. Could it be done after?

Subject: Using view totals in view

Put a zero in for the missing value instead of leaving it blank.

Subject: RE: Using view totals in view

hmmm, actually i need to calculation to occur after totally

because even the zeros, i will just get the that calculation column to zero

i.e. 3 Columns, A, B, C

A = list of 10’s, B = list of 20’s, C = A/B

but since they are values from different forms, so i get a ton of zeros in the C column, then totaled, it becomes 0, will A total = 100, B = 200, C = 0, (pretend there are 10 docs)

Subject: RE: Using view totals in view

Then what you want to do can’t be done in a view. You can code around the divide-by-zero issues on a document by document basis, but you won’t get the expected totals.

Subject: RE: Using view totals in view

okay, just wanted to double check

but thanks for your help