Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If(GetSelectedCount(OrderDate)<0,RangeSum(Above(Count({<OrderDate={">=$(=MonthStart(Today(),-12))<=$(MonthStart(Today()))"}>}OrderID)),0,RowNo())),
RangeSum(Above(Count({<OrderDate={">=$(=AddMonths(MonthStart(Max(OrederDate)),-12)<=$(=MonthStart(Max(OrderDate)))"}>})))
)
Kindly Help in this here my Problem is if i am not selecting any date it should be selected current year rolling sum other wise selected year rolling
but her it is not working it is displaying max year as cumulative values and rest it is showing all zeros even i am not selecting any year ,
if i am selecting particular then it is working fine but i want by default it should select from current month to last 12 months from current year