Search results for query: *

To follow up, here is an actual Case statement, where I am getting an error, apparently on the "substr" part of the code. Background: we use financial periods instead of months. The field [Current Fiscal Period] is a 6-character field in the format 201107 for the current period. Here is the...

Thank you very much. On a more general note, is there any written resource that will cover these kinds of syntax questions? The few books out there don't seem to get very good reviews. Paul

I am migrating reports from Crystal 11 to Cognos 8.4, after one week of training. I am having a lot of trouble, and I can't seem to find resources, other than forums, that will help with the detailed syntax questions that keep coming up. For example, why does this sample code test ok case when...

The last phrase of the second-to-last paragraph should read "and doesn't subtract when thare are [b]no[\b] empty values.

I just joined this board to research this exact problem, so I am really glad to see a recent thread on this. I seem to have been inspired by what I read here to stumble on a solution (at least it seems to work in my report): Create a formula @formulafieldnull if @formulafield = "" then 1 else 0...