@Bellave_Jayaram It becomes NaN (not a number) after listing 2 numbers. SPLIT((SELECT(BET[On Hold Duration],[BET Title]=[_THISROW].[BET Title])))+LIST(HOUR([On Hold Stop]-[On Hold Start])*0.04167) – this returns no. of days each time I update On Hold...

hi @Bellave_Jayaram. in order to use SUM, [PauseDuration] must be of Base Type Number. however, it only lists up to two numbers. any workaround?