Display one figure from multiple Lines

[RichardLee]

I have a data set with Credit limits and Insure limits but when I'm summing them up I need to populate each with a figure I cant have any Zero's displayed.

I've tried the following 

sum(if(aggr(distinct [Credit Limit],[Customer Acc Code])='0',aggr(avg([Insured Limit] ),[Customer Acc Code]),aggr( distinct[Credit Limit],[Customer Acc Code])))

but I dont get the result needed.  Any help will be fantastic.

[Mark_Little]

Hi,

What is the dimension you are using in the tables? 

I would think if there shouldn't be a zero in the summing it may be best to address at source? or in script?

Mark

[RichardLee]

Tried in the Data Load as well

If(SubField(Applymap('Map2Code', CT_Num), '|',5)=0,SubField(Applymap('Map2Code', CT_Num), '|',2),SubField(Applymap('Map2Code', CT_Num), '|',5)) as [Credit Limit1],
if(ApplyMap('MapAlcibCredit',Num(CT_Num))<='0.01',SubField(Applymap('Map2Code', Num(CT_Num)), '|',2),ApplyMap('MapAlcibCredit',Num(CT_Num))) as [Credit Limit1],