This content has been marked as final.
Show 4 replies
-
1. Re: Display Max Month Dynamically
Usman Ali Jan 25, 2018 9:09 AM (in response to mafalda.santos)2 of 2 people found this helpfulPlease use following calculation
IFNULL(SUM(iif([Date Time]={MAX([Date Time])}, [Values],NULL)),PREVIOUS_VALUE(SUM([Values])))
And have your desired result.
Regards
Raja Usman Ali
-
2. Re: Display Max Month Dynamically
mafalda.santos Jan 25, 2018 9:35 AM (in response to Usman Ali)HI Usman,
Thanks a lot for the help
Cheers
Mafalda
-
-
4. Re: Display Max Month Dynamically
Usman Ali Jan 27, 2018 10:25 PM (in response to mafalda.santos)Hi Mafalda,
I suggest you to please mark my solution as correct answer so other people can use this in future.
Cheers,
Raja Usman Ali