Skip to Content
0
Former Member
Jul 22, 2009 at 11:16 AM

Fox formula: Calculate Average Price

76 Views

Hi,

I will calculate the average price in a fox formula. Therefore I have to check which values of the avg. price are zero.

First user have to enter a value for the year. This value will be devided linear and in next screen shown in a monthly basis (like example below). Now the user can overwrite this values by setting the value of a month.

The value of the average price should not be calculated and saved as a sum. Therefore I have to calculate it in formula to save it back.

Example:

Avg. Pr

Jan 67

Feb 0

MAR 67

Apr 67

Mai 67

Jun 0

Jul 67

Aug 67

Sep 0

Okt 67

Nov 0

Dez 67

How to do that? Result should be the sum of Avg. Pr. / 8...

Regards

Andreas