topic Re: Max Year and Max Month Together in Set analysis giving 0 by default in App Development

Max Year and Max Month Together in Set analysis giving 0 by default

Alarkis — Sat, 16 Nov 2024 02:22:28 GMT

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.

Re: Max Year and Max Month Together in Set analysis giving 0 by default

Taoufiq_Zarra — Thu, 21 May 2020 02:52:23 GMT

@Alarkis

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

Re: Max Year and Max Month Together in Set analysis giving 0 by default

Alarkis — Thu, 21 May 2020 03:09:40 GMT

same issue on all kpis

i tried both with max not working

n > N was mistype on forum

regards

Re: Max Year and Max Month Together in Set analysis giving 0 by default

Taoufiq_Zarra — Thu, 21 May 2020 03:11:51 GMT

can you share a sample data ?

Re: Max Year and Max Month Together in Set analysis giving 0 by default

Alarkis — Thu, 21 May 2020 03:24:29 GMT

Sample:

iam using Calender and datebrige also.

Re: Max Year and Max Month Together in Set analysis giving 0 by default

Taoufiq_Zarra — Thu, 21 May 2020 03:27:33 GMT

and year and MonthNum ?

Re: Max Year and Max Month Together in Set analysis giving 0 by default

Alarkis — Thu, 21 May 2020 03:36:19 GMT

from master calander

Re: Max Year and Max Month Together in Set analysis giving 0 by default

Taoufiq_Zarra — Thu, 21 May 2020 03:55:46 GMT

can you try with

=count({<APPLICATION_DATE = {"$(=Date(Max(APPLICATION_DATE)))"},Source={'Services'}>} APPLICATION_NO)

if APPLICATION_DATE is your calendar date

Re: Max Year and Max Month Together in Set analysis giving 0 by default

Alarkis — Thu, 21 May 2020 04:48:27 GMT

it didnt work because i had tempdate in calender