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

Fox formula: Calculate Average Price



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.


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