If I'm understanding correctly, you can't do this with a table calculation, but you wouldn't want to. You can take the difference between these fields [Average Amenity Budget] - [Average Amenity Premium]. If you just want to know above or below, you can normalize by dividing by the absolute value of the same thing.
What might mess this up is if the table calculations aren't setup with the default partitioning that you want. You can set these up in the upper right corner of the calculation editor window (changes will only apply to new additions to your sheet) or you can right click the pill and select edit calculation (there is a drop down for underlying table calcs to setup the partitioning for each.
[Average Amenity Budget] - [Average Amenity Premium] > 0
Will return true or false based on the row calculation , If you drag that calculated field to the color column where you can assign two color for True and False. Hope it solves .This is my assumption. Let me know if you have any trouble doing it.
1 of 1 people found this helpful
Yep. Better still,
[Average Amenity Budget] > [Average Amenity Premium]
Thanks so much. I'm not sure what I was doing yesterday when I tried this...I thought I did something similar and it did not work properly. This works great!
Thanks so much! This works great. I have no idea what I was doing yesterday...I thought I did the same thing, but it didn't give me the correct results.