This content has been marked as final. Show 6 replies
I am trying to create a dimension that is derived from 3 fields and i am having a difficult time.
There should end up being three values-
This is the SQL I use currently which works as expected -
case when M =1 then 'Mar'
when LeadSource = 'C' or LeadSource='P'
or M = 0
not in (,'Direct','Sales','Brought',') then 'Partner'
else 'Rep' end
Here is what I have now in my app, but I cant get this worked out ----
If(M = '1', 'Mar',
If(M = '0','Partner'
If(Match(Dbb,'Partner') = 1 , 'Partner','Rep Created')))
This only returns 'Mar"
Any help pointing me in the right direction would be greatly appreciated.