CHAPTER 9Using Column Formulas to Apply Logic and Transform Data

Copyright © 2009 by The McGraw-Hill Companies, Inc. Click here for terms of use.

This chapter has two distinct topics—adding logic to your report and changing the format of data in report columns. I considered putting this chapter in front of the other function chapters, because it seems that nearly every column formula I write includes one or more of the functions described in this chapter. I ultimately decided that this should be the final chapter on functions because you will rarely use any of these functions entirely on their own.

With CASE statements, you are instructing Answers On Demand to react to specific conditions and perform a certain calculation in one case and another ...

Get Oracle CRM On Demand Reporting now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.