Want Expression to get average closing value

[Anonymous]

Hi,

I  attached my sample data and i want to get avg closing value for selected date from my source Table data.

i used this below expression but not work

num((((sum({1<DOCDATE=$::DOCDATE,

DOCDATE = {"$(01/04/2018)"},

MOVEMENT={'1'}

>}STOCK))

+

(sum({1<DOCDATE=$::DOCDATE,

DOCDATE = {">$(01/04/2018)<$(vFromDate)"},

MOVEMENT={'1'}

//DOCDATE = {'$(vFromDate)'}

>}STOCK)))

-

(sum({1<DOCDATE=$::DOCDATE,

DOCDATE = {">$(01/04/2018)<$(vFromDate)"},

MOVEMENT -= {'1'}

>}STOCK)))

/

Count(DISTINCT{1<DOCDATE=$::DOCDATE,

DOCDATE = {">$(01/04/2018)<=$(vFromDate)"}>}DOCDATE)

+

(sum({1<DOCDATE=$::DOCDATE,

DOCDATE = {">=$(vFromDate)<=$(vToDate)"},

MOVEMENT={'1'}

>}STOCK)

-

sum({1<DOCDATE=$::DOCDATE,

DOCDATE = {">=$(vFromDate)<=$(vToDate)"},

MOVEMENT={'-1'}

>}STOCK))

/Count(DISTINCT DOCDATE)

,'##0')

Thanks advance

Sasikumar