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