How to apply max function to a variable in set analysis

sravankv — Sat, 16 Nov 2024 03:55:34 GMT

Hi All,

I have 2 different dates in my data set(Manufacture and Sale). Now the requirement is to create a KPI which always shows max year and month count.

for which i can write 2 expressions for each date, which works perfectly. ex:

='Manufacure Count: '&Count({<Mani_Month_Nm={"$(=max(Mani_Month_Nm))"}, Mani_Year={"$(=max(Mani_Year))"}, Mani_Month>}Item)

='Sales Count: '&Count({<Sal_Month_Nm={"$(=max(Sal_Month_Nm))"}, Sal_Year={"$(=max(Sal_Year))"}, Sal_Month>}Item)

But, i want to avoid writing 2 expressions and make dynamic a single one.

=Count({<$(vMoM)={"$(=max($(vMoM)))"}, $(vYoY)={"$(=max($(vYoY)))"}, $(vM)=>}Item)

Here the problem is applying max function to the variable(it is not working).

Appreciate any help(attached sample app).

Re: How to apply max function to a variable in set analysis

Anil_Babu_Samineni — Mon, 08 Apr 2019 08:42:41 GMT

How is the variables define?