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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.