Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Payeras_BI

if you check, we need to have a target of 2,3 and 5 for the same activities ID under the same affiliate owner.

so the logic is that we want all those targets to show on that column so we can calculate the SLA % to indcate that

2=70%

3=85%

5=95%

 

i hope this will make it easy for you to understand the logic

Payeras_BI's avatar
Payeras_BI
Solution Sage
5 years ago

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