Total mode expression total return 1

[agastya]

Hello All,

I am facing issue with Total Mode Sum and Expression Total .If i am selecting Sum as a total mode its giving proper count if i am trying to change it to Expression total value returning 1

count(DISTINCT aggr(if(AGGR(if(min(DRAWING_REVISION_Number)='','',if(min(TOTAL<Test> DRAWING_REVISION_Number) and min(DRAWING_REVISION_Number)=1,
'1',if(min(TOTAL<Test> DRAWING_REVISION_Number)=min(DRAWING_REVISION_Number),-1,min(DRAWING_REVISION_Number)))),DRAWING_REVISION_Number,Test)
>1,COUNT(DISTINCT Test)),DRAWING_REVISION_Number, Test))

@sunny_talwar 

[Chanty4u]

Are you using any synthetic dimension in your chart?

[agastya]

No chanty 

[Chanty4u]

can you try with sum of rows option?  still same issue?

[agastya]

Sum of rows giving proper O/P as i shown in screenshot