I'll be honest - the main reason I write these articles is because I can't remember the techniques for 5 minutes. If I blog it and put it on the menu I can always find it again.
The topic du jour is how to refer to a report field in a formula.
Now, I'm 100% SQL, I do everything in SQL. If it can be done there, that's what I do.
But in this case there was an odd grouping going on in the report, and I needed to refer to a report cell in a formula. The technique is below