Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So, let's say I have 3 selection boxs, one for the year, one for the month, and one for the day.
And I have this database:
Year Month Day Sales
2013 6 4 150
2013 6 3 250
2013 6 2 200
2013 6 1 100
So, when I select Day 3, Month 6 and Year 2013, I want to see 550. And when I select Day 4, Month 6 and Year 2013, I want to see 700.
This is what I'm trying
Sum({$<Year= {$(#=Only(Year))}, Month= {$(#=Only(Month))}, Day= {'>=1 <=$(=Only(Day))'}>} Sales)
but i'm not having any luck. I get a 0.
Thanks in advance for the help community!
Try sum({<Year={$(=only(Year))},Month={'$(=only(Month))'},Day={'<=$(=only(Day))'}>}Sales). Note the quotes for the Month search string.
=sum({$<year={"$(=Max(Year))"},month={"<=$(=Max(Month))"},day={"<=$(=Max(Day))"}>}sales)
Try sum({<Year={$(=only(Year))},Month={'$(=only(Month))'},Day={'<=$(=only(Day))'}>}Sales). Note the quotes for the Month search string.
It's not working. I mean, I get a number at least now, but It's faaaaaaaaaar higher than my intended one
It works now on our document! Thanks a million for your fast and awesome help!
=sum({<Year={$(=only(Year))},Month={'$(=only(Month))'},Day={'<=$(=only(Day))'}>}Sales)
=sum({<Year={$(=MAX(Year))},Month={'<=$(=MAX(Month))'},Day={'<=$(=MAX(Day))'}>}Sales)
=sum({<Year={$(=only(Year))},Month={'$(=MAX(Month))'},Day={'<=$(=MAX(Day))'}>}Sales)
in LAST 2 expre u will get the correct output but u need to clck the year and day and month to see the correct output
but first expre u will get the excat one with out clicking. as gybert said
thanks gysbert i am great follower of u
because of u i learned another new thing today