Expression Calculation

[Ironzem]

I have an expression which gives the correct result if filtered for a single day but when multiple days are selected the calculation goes array. I need to set this expression to give me a sum of per day calculation.

This is my current expression -

Rangemax(count({$<[FlagCheckin]={1}>} FlagCheckin) + RangeMax(count({$<[FlagExit]={1}>} FlagExit) - count({$<[FlagCheckin]={1}>} FlagCheckin) - count({$<[FlagTransfer]={1}>} FlagTransfer),0) + Sum({<FP_TYPE={'Transfer'}>}Flag),1)

On a table where I include a date dimension , calculation results is correct - on the summary table it is wrong

[Rockstar7 · Accepted solution]

@Ironzem  apply Aggr() to you expression with token number & Date like below

Aggr(expression,Token Number,Date)

[Ironzem]

Thank you , worked perfect .  just added Sum (Aggr (expression,TN,Date))