topic Re: Set analysis with previous date in App Development

Set analysis with previous date

PuriVelasco — Sat, 16 Nov 2024 20:46:16 GMT

Hello,

I want to achieve number of occurrences for current and previous month in a table.

For previous month I am using:

Count({$<[Servicio.MesAno]={"$(=MonthName(addmonths([Servicio.MesAno],-1)))"}, Servicio.alturaModulo={"pies"}>} Servicio.codArticulo)

where Servicio.MesAno is like ene. 2019, feb. 2019, etc.

My sentence doesn't run. I need your help.

Thank you very much

Re: Set analysis with previous date

Anil_Babu_Samineni — Wed, 29 May 2019 13:00:10 GMT

Perhaps this?

Count({$<[Servicio.MesAno]={"$(=addmonths(Max([Servicio.MesAno]),-1))"}, Servicio.alturaModulo={"pies"}>} Servicio.codArticulo)

Count({$<[Servicio.MesAno]={"$(=Date(addmonths(Max([Servicio.MesAno]),-1),'Date Format'))"}, Servicio.alturaModulo={"pies"}>} Servicio.codArticulo)

Re: Set analysis with previous date

PuriVelasco — Wed, 29 May 2019 13:42:52 GMT

Sorry Anyl but don't run.

Re: Set analysis with previous date

Anil_Babu_Samineni — Wed, 29 May 2019 13:58:44 GMT

What it is returning?

MonthName(AddYears(Max(Servicio.MesAno),-1))

Re: Set analysis with previous date

PuriVelasco — Wed, 29 May 2019 14:00:52 GMT

may. 2018

Re: Set analysis with previous date

Anil_Babu_Samineni — Wed, 29 May 2019 14:26:08 GMT

Better, If you could draft sample data for us, Try this way

Count({$<[Servicio.MesAno]={"$(=MonthName(addmonths(Max([Servicio.MesAno]),-2)))"}, Servicio.alturaModulo={"pies"}>} Servicio.codArticulo)

Re: Set analysis with previous date

PuriVelasco — Wed, 29 May 2019 14:27:09 GMT

I would have in a table the next fields.

Current month - Last month - Last year

And in each field their values of codArticulo.

I have the data from the data base but I don't know how I have to write to see them in the table. Now I only see the current month data.

Thank you for your efforts.

Re: Set analysis with previous date

Anil_Babu_Samineni — Wed, 29 May 2019 14:35:17 GMT

Would you able to share sample and expected result?

Re: Set analysis with previous date

PuriVelasco — Wed, 29 May 2019 14:42:29 GMT

In the 'Actual' field we can see the data for the current year and month. In the 'Mes pasado' field I would like see the data of last month.

Thank you.

Re: Set analysis with previous date

PuriVelasco — Wed, 29 May 2019 14:44:31 GMT

In row ene. 2019 field 'Mes pasado' I would have to see the data of dec. 2018; in row feb. 2019, the field 'Mes pasado' would show the data of ene. 2019, etc.