Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
it's very strange, it should works or return 0 but not NULL.
I Agree with you
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: