How to manage a null value.

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to manage a null value.

vishsaggi — Mon, 30 Apr 2018 20:50:28 GMT

Can you share a sample to look into please?

Anonymous — Wed, 02 May 2018 16:23:04 GMT

i resolved it. Many thanks.