Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Max Year and Month in set analysis is giving 0 value until i click on a year..
max year works alone...
Max month works alone but gives wrong results..until i select year.
when i combine them together it gives 0 until i select i year.
count({$<Year={"$(=vCurrentYear)"},MonthNum={'$(=CurrentMonth)'},Source={'Services'}>}APPLICATION_NO)
Variables:
vCurrentYear is =Max(Year)
CurrentMonth is =Max(MonthNum)
its giving
until i click on a year:
its correct but i want to display Max Year and Max Month value by default..
Thanks.
Sample:
iam using Calender and datebrige also.
I can' see anything wrong with the expression except :
count({$<Year={"$(=vCurrentYear)"},Monthnum={'$(=CurrentMonth)'},Source={'Services'}>}APPLICATION_NO)
N->n
if you select and you will get the right results so just check this combination MaxMonth and Maxyear with Source=Services and if Application_no exist with this combinaison
same issue on all kpis
i tried both with max not working
n > N was mistype on forum
regards
can you share a sample data ?
Sample:
iam using Calender and datebrige also.
and year and MonthNum ?
from master calander
can you try with
=count({<APPLICATION_DATE = {"$(=Date(Max(APPLICATION_DATE)))"},Source={'Services'}>} APPLICATION_NO)
if APPLICATION_DATE is your calendar date
it didnt work because i had tempdate in calender