topic Re: MTD function in set analysis in App Development

MTD function in set analysis

VVJ — Sat, 16 Nov 2024 21:41:44 GMT

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.

Re: MTD function in set analysis

Somasundaram — Sun, 23 Dec 2018 11:01:23 GMT

Try this,

sum({<day={">=(=monthstart($("vmaxdate")))<=($("vmaxdate"))"}>}sales)

Re: MTD function in set analysis

hemachandran — Sun, 23 Dec 2018 15:47:50 GMT

Hi,
Please try this
sum({<day={">=(=monthstart($("vmaxdate")))<=(=$("vmaxdate"))}>}sales)