Hi, I am new to Cognos and trying to create a dynamic column in the first block of my report. I have added two columns in query level and added some calculation( expression) for both columns. YTD and IYTD budget. I also created a prompt and drag a query calculation to my report and added the following sql:
Case ?pYTD?
When 'YTD' Then [BVA (query)].[YTD Budget]
When 'IYTD' Then [BVA (query)].[IYTD Budget]
ELSE (0)
END
The problem is I get a error that cannot find query. If I drag a field from Frame Manager to query it works, but I cannot add my columns in Frame Manager and have to work in query level.
This works but I can not add additional calculation to split the original column to two.
Case ?pYTD?
When 'YTD' Then [Model].[Ledger].[All Budget lines]
ELSE (0)
END
Any suggestions?
Thanks