aggregate

[neha_sri]

Hi,

I have data at Dyn Pump param id and I wantit to sum on Zone level ,

I have used following expression

aggr(sum( if([%Link Pump Group]<>[DYN Pump Group Id] ,

if( [Pump ID]=[DYN Pump Id] ,

if(  IsNull([DYN Pump Param Id])=0,Volume)))),[DYN Pump Param Id],[DYN Pump Param Id],[Zone Name])

My data is repeating,

For Zone Central the answer should be 35572.33.

Please correcty my expression

Thanks

[#2]

Try

SUM(TOTAL <Zone Level> Volume)

[its_anandrjs]

Write like

aggr(sum( if([%Link Pump Group]<>[DYN Pump Group Id] ,
if( [Pump ID]=[DYN Pump Id] ,
if(  IsNull([DYN Pump Param Id])=0,Volume)))),[DYN Pump Id],[DYN Pump Param Id],[Zone Name])

Or

aggr(sum( Total if([%Link Pump Group]<>[DYN Pump Group Id] ,
if( [Pump ID]=[DYN Pump Id] ,
if(  IsNull([DYN Pump Param Id])=0,Volume)))),[DYN Pump Id],[DYN Pump Param Id],[Zone Name])

Regards

Anand