Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I have an expression
=sum({<Date={">=YearStart(max(Date)))<=$(=max(Date))"}, Year=, Month=, >} Amount)
and i got filters for year and month and my expectation is if I select the year 2015 and month May then I should see the chart with only data from 01/01/2015 to 05/31/2015 but it even shows the data from Dec, 2014.
What am i missing here?
Thanks,
jean
Hi,
I'll think you now only find this part "<=$(=max(Date)", try to add a $ and a = here:
sum({<Date={">=$(=YearStart(max(Date)))<=$(=max(Date))"}, Year=, Month=, >} Amount)
can you please post oyur app
Hi Deepak,
It would be difficult for me to post app because it got a lot of sensitive data.
Can you figure out any issue by just looking at the expression? Shouldn't it work as i am expecting?
have i used Year=, Month=, correctly?
Thanks
Hi,
I'll think you now only find this part "<=$(=max(Date)", try to add a $ and a = here:
sum({<Date={">=$(=YearStart(max(Date)))<=$(=max(Date))"}, Year=, Month=, >} Amount)
Have you tried without this part: Year=, Month=
=sum({<Date={">=YearStart(max(Date)))<=$(=max(Date))"}>} Amount)
Qv will ignore Year and month selections because of this Year=, Month=
ok...the $ sign was there and i had missed the "=" so it added but it still brings from 2014.
You have an extra closing bracket in the YearStart expression, I think.
try by removing this Year=, Month=,
Hey
it worked...i think the problem was missing "="..
Thank you
yes that was also a problem.
Thanks.