Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
Why is this expression not working ?
is there anything that i need to change ?
=sum({$<year=("$(=year(Today())))"}>}runs)
Thanks in Advance
Instead of Year put "Date"
Yes you have to change it like below
=sum({$<year= {"year = Year(Today())"}>}runs)
I think there is one closing ) too much:
=sum({$<year=("$(=year(Today()))"}>}runs)
=sum({$<YEAR = {"($=Year(Today()))"}>}runs)
Hi Anil,
This is not working
As stefan notice one parenthesis looks like extra
This is giving me the whole total ,
I want to display for the current year today the sum of runs
HI stefan ,
THis is what i get the expression higlighted by the red lines ..and is nto giving the desired output
instead of open braces ( put curly braces {
Try this?
=sum({$<year=('$(=Year(Today()))'}>}runs)
or
=sum({$<year=('$(=Max(year))'}>} runs)
Note - I've seen reply to Stefan. Try above