Query Calculation and Dynamic Column issue

[dustcluster]

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