Text Var not working correctly in workbook

Hello all,

I have created a text var which is working on replacement path on 0calday.

i have added this text var in a query and ran through query designer ( execute through web ) it is showing correct results.

i have created a workbook whereas i have added this query and some other similar queries as well .

Now when i run the workbook , it is showing incorrect results for text var , while as when i am running query individualy ; it is showing correct results.

Kindly advice ..

Regards,

CR