Max(Date) with Set Analysis

[eduardo_dimperio]

Hi,

I need to get the difference between consume of first and last month from each neighborhood, my problem is that some neighborhood have less months than others, but in set analysis it gets the max (date) of all neighbors and not individual,

ex this two pictures without selection and with selection. How do i do to fix that?

I have this code:

(

(SUM({<DATA_EXTRACAO  = {"$(=DATE(MAX(DATA_EXTRACAO)))"},CONS0={">=0"},GROUP_TYPE_METER={"AGUA"}>} CONS0)-

SUM({<DATA_EXTRACAO  = {"$(=DATE(MIN(DATA_EXTRACAO)))"},CONS0={">=0"},GROUP_TYPE_METER={"AGUA"}>} CONS0))

)

/

If(

SUM({<DATA_EXTRACAO  = {"$(=DATE(MAX(DATA_EXTRACAO)))"},CONS0={">=0"},GROUP_TYPE_METER={"AGUA"}>} CONS0)>0,

SUM({<DATA_EXTRACAO  = {"$(=DATE(MAX(DATA_EXTRACAO)))"},CONS0={">=0"},GROUP_TYPE_METER={"AGUA"}>} CONS0),1

)

Thanks

[agigliotti]

it's very strange, it should works or return 0 but not NULL.

[eduardo_dimperio]

I Agree with you

[eduardo_dimperio]

People, i tried this

(SUM({<DATA_EXTRACAO  = {"$(=AGGR(DATE(MAX(DATA_EXTRACAO)),bairro))"},CONS0={">=0"},GROUP_TYPE_METER={"AGUA"}>} CONS0))

-

(SUM({<DATA_EXTRACAO  = {"$(=AGGR(DATE(MIN(DATA_EXTRACAO)),bairro))"},CONS0={">=0"},GROUP_TYPE_METER={"AGUA"}>} CONS0))

But with this result: