Please post some data.
The sample data is in the picture I included, but a basic example is:
Today revenue: $50,000
Yesterday Revenue: $49,000
Change vs. Yesterday: +2%
Something like this:
Sum(If [Date] = Today() then Revenue End)
Sum(If [Date] = Today() -1 then Revenue End)
▲ = (Today / Yesterday) - 1
Thanks for the response. I'm not having any problems with the calculations, what I'm having problems with is getting a text box (or cell in a table) to show the calculation with dynamic text. Let's say I have a calculated field called [Pct Chg Yesterday], I want the value in the cell to have a concatenation of "+" or "-" depending on if it was a positive or negative change + [Pct Chg Yesterday] + " vs. yesterday". So, if the change was +2% from yesterday, the textbox/cell would display "+2% vs. yesterday" and the background would be green.