Issue in Expression-Count not correct

[#1]

Hi,

PFA for the Sample QVW.

This works when i select for one person.

For Person_addm2_key = 418 it is 384

and for Person_addm2_key = 429 its is 121.

when i select both the PErson_addm2_key i should get the value : 384 + 121=505

But i am getting no values.

can you please check the expression and help?

[MayilVahanan]

HI

Try like this

=Sum(Aggr(Interval(MAX_SMOKE_QA_TIMESTAMP-JOIN_DT,'d'),PERSON_ADDM2_KEY))