Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Someone can give me a formula for previous year sum value, as shown in the pictures?
Current Year:
Sum({$<[Date] = {">=$(=Yearstart(Max([Date]))) <= $(=Date(Max([Date])))"}>} value)
Previous Year: ?
Try with: Sum({$<[Date] = {">=$(=Yearstart(Max([Date]),-1)) <= $(=YearEnd(Max([Date]),-1))"}>} value)
Eduardo
Or this:
Sum({$<[Date] = {">=$(=YearStart(Max([Date]), -1))<=$(=YearStart(Max([Date])) -1))"}>} value)