Fox formula: Calculate Average Price

[Former Member]

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

[Former Member · Accepted solution]

Loop at the calendar month, use an if condition to check if the key figure is zero and update the temporary count variable. after the loop subtract the count used in the loop from 12 and calculate the average and update the result.