Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, Could someone explain me why my set analysis is given me zero as an result:
sum({$<EndDate={"$(>=AddMonths(monthname(today()),-6))"}>}Volume)
My intention is to get volumes from last full six months.
Br
Try this
Sum({$<EndDate={"$(='>=' & AddMonths(Today(), -6))"}>}Volume)
ITry like this:
sum({$<EndDate={">=$(=AddMonths(monthname(today()),-6))"}>}Volume)