We are creating a table in a custom report specific to Application spend trend.  We created a new calculated metric (Period Trend) that calculates the variance between the previous 6 months and the most recent 6 months.  If costs are trending up, Period Trend will be positive. If costs are trending down, it will be negative. We have this working fine.

Now, we would like to highlight where Period Trend is negative - I’m having trouble getting this formula to work.  It’s not throwing an error, but it’s also night highlighting anything. Any advice?

=IF({Period Trend}<0,"yellow","clear")

We’ve also tried:

=IF({Period Trend}<Value("$0"),"yellow","clear")

and a few other iterations.

Ultimately, we would like the logic to look at Investment Objective and Period over Period trend for each app.  If Investment Objective is “Invest” and Period over Period trend is a negative amount, highlight the Investment Objective yellow..  Conversely, if Investment Objective is “Eliminate” and Period over Period trend is positive, highlight the Investment Objective yellow.  Baby steps….

Hello,

The first formula you show above should work. You have to select the column that you want to add the highlight to in the table and then go to the data tab and enter the formula using "Highlight". I would also suggest that the column be a number column or <, =, etc might not be recognized.

Here is a screenshot I took doing what you are trying to do:

Hope this helps. 

Thanks,

Christy