Your last line gave me finally the clue and it gave the answer of the issue. It looked like there were a lot of quotes 'randomly' placed as result. After some trial and error the final syntax had to read: and SDkcoo in (@{PVCompanynr}['@']{00001}) Please ignore new presentationvariable name since I modified it for…

Appeared to be an error in the datamodel caused by unknown reasons. Problem solved by rebuilding the datamodel and not using the logical SQL but creating queries directly to the database.

Dear Joel and Gianni, Thank you for your quick reply. I will have a look and keep you informed.

Hi Jerry, I used your advice and my earlier solution, and it works fine. Thanks.

Hi Jerry, Thanks for your extensive reply. Reading this I remembered that I did something similar with months but then I was deducting numbers. I am going to figure out if it works when adding numbers.

Hi Christian, thank you for your counter-question, you mean something like Timestampadd(TSI_SQL_Year, 1, @PVYearnr)? It didn't work because of different data-types. The result from @PVYearnr is a number instead of a date-serie. Maybe I should rebuild all to a 'real' date-format?

page 1 page 2 page 3 page 4

Hi Joel, Thanks for quick response. Your suggestion seems to work although I still get some unexpected results. For example, the columns headers don't respond to the contents of the columns anymore. To be honest I'm struggling with this problem (the extra columns and calculating with results) for several days and find it…