Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hey ALL
i have a problem in how to write the following expression :
i have two field first one is the 'clientID' and the seconde field is the 'Destination ClientID'.
there is a transfer of produts between the 'clientID' and the 'Destination ClientID' , i need to calculate the Sum of Products transfered but with condition that the 'Destination ClientID' should be Different then The ClientID (to disregard the transfer between the sameIDs) i need to calculate id without using a Variable if it's Possible .
Help
Thanks
maybe a sum/count if
sum(if (client1<> client2, product))
if( [Destination ClientID] <> ClientID ,sum(product))
Hi
Please Try this Expression and let me Know
if(Sum(Product)<> [client ID] , [Destination ID])
or
if(Sum(Product)< [client ID] , [Destination ID])