topic Re: How to compute 12 months value ? in App Development

How to compute 12 months value ?

Rose1 — Sat, 16 Nov 2024 00:55:29 GMT

Hello , I want to compute the values of 12 months when choosing one month without displaying the 11 previous month .

For example : If I choose Aug 2019 I want to get the sum of values between Aug 2018 and Aug 2019 but without seeing the value of each month

Here is my expression :

count({<MonthYear ={"$(='>=' & Date(AddMonths(Max(MonthYear), -12), 'MMM-YY') & '<=' & Date(Max(MonthYear), 'MMM-YY'))"}>}distinct VProducts).
Any Help would be appreciated .

Re: How to compute 12 months value ?

Anil_Babu_Samineni — Fri, 25 Dec 2020 20:48:30 GMT

What is VProducts?

Re: How to compute 12 months value ?

Rose1 — Fri, 25 Dec 2020 21:22:51 GMT

The name of one of my rows in my table

Re: How to compute 12 months value ?

Anil_Babu_Samineni — Fri, 25 Dec 2020 21:26:16 GMT

I can understand that it is the field name, If so try this way

count({<MonthYear ={">=$(=Date(AddMonths(Max(MonthYear), -12), 'MMM-YY'))<=$(=Date(Max(MonthYear), 'MMM-YY'))"}>} distinct VProducts)

Re: How to compute 12 months value ?

Rose1 — Fri, 25 Dec 2020 21:46:46 GMT

Thank you for your help , but I ve done it before it's not giving me what I want .

It displays the 12 months with the value of each month what I want is the sum of the 12 months values in one column.

For example if I choose oct-20 my result in the pivot table would be the sum of sep 2019 value till oct 2020

Re: How to compute 12 months value ?

Anil_Babu_Samineni — Fri, 25 Dec 2020 21:49:53 GMT

Where are you trying this, Is this KPI or some chart? If chart what is the dimension?

Re: How to compute 12 months value ?

Rose1 — Fri, 25 Dec 2020 21:57:02 GMT

Pivot table , my dimendion is MonthYear

Re: How to compute 12 months value ?

Anil_Babu_Samineni — Fri, 25 Dec 2020 22:00:16 GMT

If that is the case, You won't get only single row. But, If i misunderstand the requirement you can explain more the expected result at least image?

Re: How to compute 12 months value ?

Rose1 — Mon, 18 Jan 2021 14:38:38 GMT

Hello again ,

Actually I used A different formula and get the result I was expecting to get but I only have on small issue I don't want those months with null values to be displayed , I tried to uncheck include the null value in my dimension MonthYear but it didn't worked

THIS IS MY EXPRESSION

Rangesum(before(Total count({<MonthYear>}distinct CLAIM_NUMBER),0,12)) * Avg(1)

thank you

Re: How to compute 12 months value ?

Rose1 — Fri, 12 Feb 2021 11:38:38 GMT

Does anyone by chance solved the same problem I am having?