Forum

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...

Hi Mike, Thanks for taking the time to look at this again. I can see what you have done differently to my original query. As mentioned mine worked ...

Hi Mike, Thanks for the reply and the file. I was trying to avoid the need for the users to launch the query editor. I wanted to pick the value up ...