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