I have a basic opportunity field history report that's filtered so I'm only looking at changes in Amount. I want a column that shows me the difference between the new value and the old value. I tried creating a summary formula as follows:
NEWVAL:UNIQUE - OLDVAL:UNIQUE
I only included
unique because without it, Salesforce keeps telling me there are no such fields as
oldval, though they do show up with "unique" at the end. I also tried using the
value() function before each field, but that didn't work.
Right now, nothing shows up in that column. I'm guessing it's got to do with me including
unique, but I'm not sure. What am I doing wrong?