Hi
I have the following problem.
I have to obtain in a table a list of the new active clients.
I have an SQL table where theres a list of clients with a flag called: Fcliact that show if the client is active in a month, it is a history table.
The problem to solve is that:
The user can select from a calender two dates that represent a period, the selection is saved in two variables,
The first one is called:
vMinimaFechaSeleccionada
and the last one :
vMaximaFechaSeleccionada
-Value 1:the client is active for a particular month
-Value 0: the client is inactive for a particular month
I have the next expression in order to resolve that, but does not work.
if(
if(isnull(sum({<VincPymeDetalle.fechaVincPyme={'$(vMaximaFechaSeleccionada)'}>} VincPymeDetalle.fcliact)),
0,sum({<VincPymeDetalle.fechaVincPyme={'$(vMaximaFechaSeleccionada)'}>} VincPymeDetalle.fcliact))
-
if(isnull(sum({<VincPymeDetalle.fechaVincPyme={'$(vMinimaFechaSeleccionada)'}>} VincPymeDetalle.fcliact)),
0,sum({<VincPymeDetalle.fechaVincPyme={'$(vMinimaFechaSeleccionada)'}>} VincPymeDetalle.fcliact))
>0,1,0)
Sorry for the tabulation, i puted it in that way to be more friendly understanding.
I someone can help me.
Many thanks
