How to manage a null value.

[Anonymous]

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

[vishsaggi]

Can you share a sample to look into please?

[Anonymous]

i resolved it. Many thanks.