Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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],