Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I am using this line of code to get the max number of YearMonth. Right now it depends on the selection of the data and this causes some problems. I really wanted to make this only depend upon selected Metrics, selected Intervention but nothing else. How can I do it?
'Max({<'& only(%Metrics) & '={1}, ' & only(%Intervention) & '={0}>}YearMonth)'
Thanks.
Try with this:
Max({1< %Metrics={1}, %Intervention={0} >} YearMonth)