Forum

Hi Mynda, I knew there had to be a simple solution. I didn't get as far as looking at the advanced options. Your solution works perfectly. Than...

Hi Catalin, Thanks for the response but what you have posted does not seem to relate to my question in this case. Should you reply be against anoth...

Thanks Sunny. For my purposes I will need the helper column as in the actual report I need to apply this to the PO Number does not necessarily run in ...

Hi Sunny, Thanks for the response that works well. I also found a solution myself which is similar but uses the =ISEVEN and =ISODD formula. ...

Hi Catalin, I was not trying to demonstrate to you the error messages I am receiving I am aware that you will not be able to connect to the databas...

Hi Catalin, I am struggling to get this to work. If you look at the attached file you will hopefully see what I am trying to do. There is a shee...

Hi Mynda/Catalin, I am surprised that the query is faster using SQL. I was really hoping to use PQ logic rather than SQL. Thanks for the input r...

Hi Mynda, Thanks for the reply. That works a treat. I am never sure whether to start the query from a folder or a file. Can I just take this op...

Hi Mike, I got the other users to test the refresh with the query updated to use your method. I can confirm that it all worked fine so problem solv...