Go back one row

cristianj23a — Thu, 18 Jan 2018 20:52:09 GMT

Hi Guys.

Mainly I have a table with the CESADOS and ACTIVOS columns.

Then we divide CESADOS / ACTIVOS.

But there was a case, that CESADO has to go back one row to do the calculation CESADO / ACTIVOS.Use the BELOW () sentence,

to go back une row in CESADO.

So far so good, but when I select a day, no value appears. example

Select:

Mes: ene

Día:4

must be obtained.

I am using the BELOW () statement so that the values of CESADOS, go back one day or row.

Please help me get that value when I select a day.

Like when I select a Month, would like to obtain the average of Assets, Cesados and the percentage.

Mes = 'ene'

The average is

CESADOS = 49

ACTIVOS = 8291

Below(CESADO)/ACTIVO = 0.60%

I attach the Qvw y Xls.

Re: Go back one row

sunny_talwar — Fri, 19 Jan 2018 20:46:53 GMT

Third post? Check here