Expression Calculation

Ironzem — Tue, 04 Oct 2022 10:32:53 GMT

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

Re: Expression Calculation

Rockstar7 — Tue, 04 Oct 2022 11:05:26 GMT

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

Aggr(expression,Token Number,Date)

Re: Expression Calculation

Ironzem — Tue, 04 Oct 2022 12:23:31 GMT

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

topic Expression Calculation in App Development

Expression Calculation

Re: Expression Calculation

Re: Expression Calculation