Last Month

[pgalvezt]

Hi,

I have this in my pivot:

sum({$<Mes={$(=Max(Mes)-1)},mes=>}If(Cod_Bloqueo <> 8, Deuda_Total))/Divisor

But doesn't work

Any help please Thanks

[m_woolf]

Try:

sum({$<Mes={"=$(=Max(Mes)-1)"},mes=>}If(Cod_Bloqueo <> 8, Deuda_Total))/Divisor

[pover]

You have to return the same format from the expression as the field Mes, and if the field Mes was created with the month() function you would have to try something like:

=sum({$<Month={'$(=month(makedate(max(Year),max(Month)-1)))'}>} [Sales Amount])

That and I'm curious why you have Mes and mes.

Karl

[pgalvezt]

Thank you for your reply:

sum({$<Mes={"=$(=Max(Mes)-1)"},Mes=>}If(Cod_Bloqueo <> 8, Deuda_Total))/Divisor

Bring me the same result like Sum(If(Cod_Bloqueo <> 8, Deuda_Total)))/Divisor

Yes is Mes field Error Syntaxis.

But doesn't work

[pgalvezt]

Pivot Table:

My Dimension is Period

My Formula is =Sum(If(Cod_Bloqueo <> 8, Deuda_Total)))/Divisor

How can I obtain the last month?

Thanks

[pgalvezt]

Any Help?

[m_woolf]

Perhaps if you posted a sample qvw?

[pgalvezt]

There goes thanks.

[m_woolf]

Your qvw doesn't contain any data.

[pgalvezt]

I tried this:

sum({$<Mes={$(=Max(Mes)-1)}>}If(Cod_Bloqueo <> 8, Deuda_Total))/Divisor

But still doesn't work