Forum Discussion
If statement using Custom Column
Hi Team im trying to get the logic of how i would make this work so that it can dispay everything not just the first command under Custom column, Please help if[AffiliateOwnerID]=2 and [Activ...
Hi Anonymous ,
Not sure if this is what you are looking for but try with this instead to get an idea of why the previous code was not working and take it from there.
= if[AffiliateOwnerID]=2 and ([ActivityTypeID]=1 or[ActivityTypeID]=2) then 2
else if [AffiliateOwnerID]=3 and ([ActivityTypeID]=1 or[ActivityTypeID]=2) then 3
else if [AffiliateOwnerID]=5 and ([ActivityTypeID]=1 or[ActivityTypeID]=2) then 5
else null
Hi Payeras_BI it is for the same affilate owner that have affiliate owner 2, it just have 3 different targets. Do you perhaps have an idea of how we can achieve that