O'Reilly logo

Oracle CRM on Demand Reporting by Michael D. Lairson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required