Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Could you please help me?
I want to filter my data with the following data:
if((sum(if([Dep/Ret]='721' and Date(Fecha_mov)<'01/04/2016' ,Movimientos)))=0 and ((sum(if([Dep/Ret]='721' and Date(Fecha_mov)>='01/04/2016' ,Movimientos))) +(sum(If([Dep/Ret]='704' and Date(Fecha_mov)>='01/04/2016',-Movimientos))) -Saldo)>0, 'Cliente a contactar','no')
if((sum(if([Dep/Ret]='721' and Date(Fecha_mov)<'01/04/2016' ,Movimientos)))=0
and ((sum(if([Dep/Ret]='721' and Date(Fecha_mov)>='01/04/2016' ,Movimientos)))
+(sum(If([Dep/Ret]='704' and Date(Fecha_mov)>='01/04/2016',-Movimientos)))
-Saldo)>0, 'Cliente a contactar','no')
How could I do?
thanks a lot !!!
