Calculate a moving avg for the last n rows of the
data, Inclusive of the current row. The Moving Average (MA) is used mainly to
identify trend direction.In case if you’re not able to understand watch below Video.
Syntax: MAVG(expr,
integer)
Syntax description
expr is any
expression that evaluates to a numerical value.
Integer is
any positive integer. Represents the average
Steps: Go to Criterial – Select the Column – Right Click –
Select Edit Formula – Click on Insert function – click on Aggregate folder and
select Mavg
Example: Mavg("Sales"."Rp
Revenue",2)
No comments:
Post a Comment