Set Analysis ignoring a parameter (Point-in-Time)

[cristian_av]

Hi. I'm using a set analysis for "Time-in-Report"

When I use part of the expression as a Variable, it works as expected. But I when change the variable for the variable content, it just ignored the Cal_ID_MesAnoEP.

Can anybody tell me what am I doing wrong?

Thank you!!

This is the expression WITH the variable

=Sum({$<Cal_ID_MesAnoEP={'$(eLastMonth)'}>}

CantidadServicios)

With the variable eLastMoth defined as:

=Max(Cal_ID_MesAnoEP)

But If I do the Same, but without the variable:

=Sum( {$<Cal_ID_MesAnoEP={'=Max(Cal_ID_MesAnoEP)'}>}	CantidadServicios)
=Sum( {$<Cal_ID_MesAnoEP={"=Max(Cal_ID_MesAnoEP)"}>}	CantidadServicios)

QV just ignore the Cal_ID_MesAnoEP parameter.

[#2 · Accepted solution]

=Sum( {$<Cal_ID_MesAnoEP={"$(=Max(Cal_ID_MesAnoEP))"}>}CantidadServicios)

Could u please try the expression show above?

[cristian_av]

It worked!!

Thank you! damn dollar sign hehe

[#4]

Hi,

Please try this

Sum({$<Cal_ID_MesAnoEP={"$(=Max(Cal_ID_MesAnoEP))"}>} CantidadServicios)