Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have used a Left join below to try and combine the spend ratings into categories. Fro example I have tried to combine the Total spend of spend rating 10 and 9 into category 5. But Category 5 still displays the separate spend ratings Total spend.
How do I get Category 5 to be the sum of BOTH 10 and 9 spend ratings Total spend?
Regards,
Oscar
Try using this in the script editor
Load Rating,
if(Match(Rating,'1','2'), 'C1',
if(Match(Rating,'3','4'),'C2',
if(Match(Rating,'5','6'),'C3',
if(Match(Rating,'7','8'),'C4',
if(Match(Rating,'9','10'),'C5'))))) as RatingCategory
Resident Rating;
Hope it helps
Thanks,
Try using this in the script editor
Load Rating,
if(Match(Rating,'1','2'), 'C1',
if(Match(Rating,'3','4'),'C2',
if(Match(Rating,'5','6'),'C3',
if(Match(Rating,'7','8'),'C4',
if(Match(Rating,'9','10'),'C5'))))) as RatingCategory
Resident Rating;
Hope it helps
Thanks,
Perfect, exactly what I was trying!