Discoverer Calculations - Not Working [message #607948] |
Thu, 13 February 2014 17:01 |
|
ahoang
Messages: 1 Registered: February 2014 Location: Edmonton
|
Junior Member |
|
|
Good afternoon,
I have Discoverer 4 on my old computer and all of the calculations work fine.
I now have Discoverer 11.1.1.3.0 on my new computer.
I opened up the Discoverer Query I had before on to this new version, but the calculations are not working.
Anyone have any ideas as to why?
Do I have to change something in the new Version to get it to calculate?
One of my formulas that don't work.
Condition: Year IN ('2014') AND Month IN ('FEBRUARY')
Calculation: CASE WHEN YearMon = '201402' THEN Net Selling ELSE 0 END
Any help is appreciated.
Thank you,
Andy
[Updated on: Thu, 13 February 2014 17:01] Report message to a moderator
|
|
|