How to calculate average through notes designer

HCL Domino Domino Forum
1

Dear all,

Can any one tell what is the formula for calculating “average” through lotus designer.

For example , I have two filed called “Total Calls” and “No of calls I attended”. I want automatically calculate average of above vale.

i e total calls/No of calls I attended.

Thanks in Advance.

2

Subject: RE: how to calculate average through notes designer

I think you’re looking for the percentage rather than an average…

percent = part \ whole * 100

So, if you attended 5 calls out of 10, the percentage would be…

5 \ 10 * 100 = 0.5 * 100 = 50%

average = total \ # of elements

So, if you attended 5 calls out of 10, the average would be…

(5 + 10) \ 2 = 7.5

(average doesn’t really make sense in this context).