Toggle contents of a column based on user profile value

[Northbridge_Recruitm]

Hi i have a table of listings which has a price comparison of the listing price to an average price. I want the comparison to be able to be for the average of that users state. Im able to get each user to select their preferred state, but i want to be able to reflect that in the listing table in one column, so that the average price used in the calculation switches for each listing. There are 8 states, so I want all of the computer columns downstream of the average to switch based on whatever the user has selected.

At the moment, im half way through making 8 versions of each computed column set up but its taking me ages. is there an easier way?

Ideally, i would have a column called User State, which would change the value for every value in the whole column to the same value that the logged in user has in the State column field.

[Darren_Murphy]

Save each Users preferred Sate in their User Profile row, and then refer to that directly from your listings table.

For example, to get an average price based on the signed in Users preferred State:

• Add an if-then-else column to the Listings table:
  – If State is User Profile → State, then Price
  – Else 0
• And then do a Rollup → Average on the if-then-else column