Hello Experts,
I have calculated stock of some materials by using the following expression
RangeSum(Above(
Sum({$<MVMNT={'000','001','004','005','006','010'},DATE={"<$(vDateTo)"}>}STOCK), 0, RowNo()))
-
RangeSum(Above(
Sum({$<MVMNT={'100','101','104','105','106','110'},DATE={"<$(vDateTo)"}>}STOCK), 0, RowNo()))
so i display by date using the expression
=if( DATE>= $(vDateFrom) and DATE<= $(vDateTo) , Date(DATE,'DD/MM/YYYY'),Date($(vDateFrom),'DD/MM/YYYY') )
I want to calculate the change of stock by Date comparing with 1 year prior but when i use this expression I have to display all rows to get the right results but i want only to display a range of dates
RangeSum(Above(
Sum({$<MVMNT={'000','001','004','005','006','010'},DATE={"<$(vDateTo)"}>}STOCK), 365, RowNo()))
-
RangeSum(Above(
Sum({$<MVMNT={'100','101','104','105','106','110'},DATE={"<$(vDateTo)"}>}STOCK), 365, RowNo()))
Thanks in Advance
Regards
