Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can somebody explain me why this formula does'nt work and show the error mesage:
sum(if(Finalizada_Act =1 and sum(CantidadCont)-Sum(Aggr(Cantidad_Act, ActividadId_TTD))<>0,1,0))
And what will be the correct one. Thanks in advance.
Pat.
Hi,
Sum(if(Finalizada_Act =1 and (CantidadCont - (Aggr(Sum(Cantidad_Act), ActividadId_TTD)))<>0,1,0))
Hope it helps
Hi,
Try this,
= sum(if(Finalizada_Act =1 and (sum(CantidadCont)-Sum(Aggr(Sum(Cantidad_Act), ActividadId_TTD))<>0),1,0))
Check the value in text box - > Sum(Aggr(Sum(Cantidad_Act), ActividadId_TTD))
Hope it helps
Hi Mayil,
that doesn't work eather. The problem is that in both formula, the edit expresion box told me thet there is an error in expression.
Hi,
no, it show the same message, the brackets are not the problem.
The following sentence is working:
if((sum(CantidadCont))-(Sum(Aggr(Cantidad_Act, ActividadId_TTD)))<>0,1,0)
But when I want to sum, it does'nt work and show an error in expresion:
Sum(if((sum(CantidadCont))-(Sum(Aggr(Cantidad_Act, ActividadId_TTD)))<>0,
1,0))
Hi,
Sum(if(Finalizada_Act =1 and (CantidadCont - (Aggr(Sum(Cantidad_Act), ActividadId_TTD)))<>0,1,0))
Hope it helps
You're a genius, thank you very much.