can not subtotal when use aggr function

[#1]

Hi all,

Please see below image, Total column calculate 0 (ZERO) against some branches. Which is wrong, it suppose to give me total.

My Expression is below

if(vFromDate >= Sdate1,sum({<T_Date= {'>=$(vFromDate) <=$(vToDate)'} >}Tday),
aggr(sum(if(T_Date>=Sdate1 and T_Date <= vToDate ,Tday)), DECDDT1,Sdate1,  Branch, [Branch Name],[RSM Name]))

Is anything wrong/modify in expression?

[#2]

Please Anybody Can Help!!!

Vinay

[yevgeniy]

aggr(

if(vFromDate >= Sdate1

,sum({<T_Date= {'>=$(vFromDate) <=$(vToDate)'} >}Tday),
sum(if(T_Date>=Sdate1 and T_Date <= vToDate ,Tday)),

DECDDT1,Sdate1,  Branch, [Branch Name],[RSM Name])