Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
What's wrong with this expression?
={$<Year={$(=<Calendar.Year(Today())}>}
The formula syntax check says "OK", but the dimension shows "invalid dimension".
Thanks for your help.
Kind Regards
Tom
Hi @TomBond77 ,
maybe this:
=Aggr( only( {< Calendar.Year = {"$(=Year(Today()))"} >} Year ), Year )
I hope it can help.
Best Regards
I also tried this version, but not working too.
={<Calendar.Year={$(=<Calendar.Year(Today())}>}
Hi @TomBond77 ,
maybe this:
=Aggr( only( {< Calendar.Year = {"$(=Year(Today()))"} >} Year ), Year )
I hope it can help.
Best Regards
wonderful