Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Just trying to get some data using set analysis but running into a problem
I have a few buttons at the top where i can set the year i'm interested in
and putting this expression in
=count({$<RegYear={$(v_year)}>} distinct person_id)
works fine regardless of the year I select. e.g. 2016, 2015, 2014 , all bring back data
when i add a 2nd expression which tries to pull the previous years data using the expression
=count({$<RegYear = {$(v_year - 1) }>} distinct person_id)
the output is just a row of 0's
Can anyone spot any issues with this 2nd formula please
Try this..
count({$<RegYear={$(v_year)-1}>} distinct person_id)
Try this:
=Count({$<RegYear = {$(=$(v_year) - 1)}>} DISTINCT person_id)
=Sum({<RegYear={"$(=Max(RegYear)-1)"}>} DISTINCT person_id)