Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
i got a situation: (please see the attached screenshot), i create the master calender where i have 3 Years: 2019, 2018, 2017, Quarters, Days.
i have a question: how can i show in set expression: the next 3 Day in Year: 2019, with Years i dont have any problems, because it is possible by using of this expression: count({<Year = {"$(=max(Year))"}>}contract), but how can i make it possible with days.
Does anybody have any idea?
Thanks a lot
Beck
Yes, my expected Output is: for instance Show me the amount of contracts for next 3 days
Hi Loveisfail,
first of all, thanks a lot for your time and help. my data you can see in attached screenshot, my Situation does look like: i have an Appointment in 2019 and in 2019 i should solve for instance 5 contracts,
i want only Show dynamic on day, Monthly or quartes Basis the amount of contracts in 2019
Thanks a lot
I am sorry, Still not getting the idea of requirement. But, can you try this - If you may think this way
count({<Year = {"$(=max(Year))"}, Date={">=$(=Date(Max(Date)+3))<=$(=Date(Max(Date)))"}>}contract)
Hi Loveisfail,
Thanks a lot for your feedback
just imagine: today we have 2018 and i want to Show only the values for 2019, the data you see in attached screenshot
This is the case your expression works - If you have data for next year as well
count({<Year = {"$(=max(Year))"}>}contract) // Because, Max(Year) will return 2019 data only if you have till 2019 data. If still you have data more than 2019 as well then you can simplify using this
count({<Year = {"$(=max(Year))"}, Date = {"$('<=' & Date(Today(),'DD.MM.YYYY'))"}>}contract) // This always return till today's data for only 2019 year
Or
count({<Year = {"$(=max(Year))"}, Date = {"$('<=' & Date(YearEnd(Today()),'DD.MM.YYYY'))"}>}contract)
Hi Loveisfail,
thanks a lot for your time and Feedback, i will try to implement it and report you when i achieve any positive results.
Thanks a lot for your help