Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have three fields supporter number, last name and postcode. What I am trying to do is to put a condition on the background colour of supporter number to say if the postcode and last name combination appears twice i want the supporter number to be coloured.
I understand where to put this condition but I cannot work out what condition to use
thanks in advance
Rosie
Hello Rosie,
You may use in the color expression something like
=If(Count(PostCode & LastName) = 2, RGB(200, 200, 200))
where the "&" operator concatenates PostCode value to LastName value.
Hope that helps
Thanks Miguel
But unfortunately that is not working!
Any more help would be greatly appreciated
Hello Rosie,
What fields do you want to look for? Are they already in the table?
I have a straight table of Supporter Number as the dimension and [Postcode] and [Last Name] as expressions, I want to know if there are any repetaed postcode and last name combinations and if there is colour the supporter number a different colour
Thanks
Rosie
Hi,
Sort the table with [Postcode] and [Lastname] in ascending order and try the following expression:
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4
=if([Postcode]=peek([Postcode],-1),if([Lastname]=peek([Lastname],-1),rgb(100,100,100)))
hope this one works.
Cheers,
Haneesh
Sorry Haneesh this is not working either
any other suggestions?
Thanks
Rosie
Hi Rosie,
Can you attach your document with some sample data. I will try to update the expression to get the desired result.
-Haneesh
this is my document using just a sample
data