set Analysis Expression

[mario-sarkis]

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

[maxgro]

maybe a sum/count if

sum(if (client1<> client2, product))

[simsondevadoss]

if( [Destination ClientID] <> ClientID ,sum(product))

[#4]

Hi

Please Try this Expression and let me Know

if(Sum(Product)<> [client ID] , [Destination ID])

or

if(Sum(Product)< [client ID] , [Destination ID])

[mario-sarkis]

HI Navven,

this is wut exactly worked with me

Check this Document: set_analysis_intra-record.qvw