Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have change the position 1 value in the budget, that´s work fine, but the problem is that the new subtotal don´t show the real value. (Its not doing anything). 114506 was in the "So" position.
I attached an image for better visualization.
If(if(seg='Al',zo,if(se = 'Ju',Pa,Agr2))= 'S'
And if(seg='Al'or seg='So',Loc,if(seg = 'Ju',LoJuPa)) = 'C',0,
If(if(seg='Al',zo,if(seg = 'Ju',Pa,Agr2))= 'C'
And if(seg='Al'or seg='So',Loc,if(seg = 'Ju',LoJuPa)) = 'C',
Sum(Aggr(sum(plan),Loc)),
num(
RangeSum(sum(if(idPer=1,plan*1.19)/Mol),sum(if(idPer=2, plan/1.19)))*$(xUfMaxMes)
,if(Vis='UF','#.##0,0000' ,'#.##0'))))
Thanks!
I got it. the solution was to add sum aggr around the whole IF:
Sum(Aggr(
If(if(seg='Al',zo,if(se = 'Ju',Pa,Agr2))= 'S'
And if(seg='Al'or seg='So',Loc,if(seg = 'Ju',LoJuPa)) = 'C',0,
If(if(seg='Al',zo,if(seg = 'Ju',Pa,Agr2))= 'C'
And if(seg='Al'or seg='So',Loc,if(seg = 'Ju',LoJuPa)) = 'C',
Sum(Aggr(sum(plan),Loc)),
num(
RangeSum(sum(if(idPer=1,plan*1.19)/Mol),sum(if(idPer=2, plan/1.19)))*$(xUfMaxMes)
,if(Vis='UF','#.##0,0000' ,'#.##0')))),Loc,Agr2))
may be:
Sum(aggr(distinct sum(plan),loc))
I got it. the solution was to add sum aggr around the whole IF:
Sum(Aggr(
If(if(seg='Al',zo,if(se = 'Ju',Pa,Agr2))= 'S'
And if(seg='Al'or seg='So',Loc,if(seg = 'Ju',LoJuPa)) = 'C',0,
If(if(seg='Al',zo,if(seg = 'Ju',Pa,Agr2))= 'C'
And if(seg='Al'or seg='So',Loc,if(seg = 'Ju',LoJuPa)) = 'C',
Sum(Aggr(sum(plan),Loc)),
num(
RangeSum(sum(if(idPer=1,plan*1.19)/Mol),sum(if(idPer=2, plan/1.19)))*$(xUfMaxMes)
,if(Vis='UF','#.##0,0000' ,'#.##0')))),Loc,Agr2))