Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to calculate the sum of sales for a particular month (month start to max date). I'm using the following syntax but not able to get the desired output.
sum({<day={">=(=monthstart($("vmaxdate")))<=($("vmaxdate"))}>}sales)
vmaxdate is a variable where I have declared the max(day).
Please help to resolve this.