By using this website, you agree to our Terms of Use (click here)
I have a Generic Inquiry that is pulling some project data. I'm pulling into Excel using OData but I am having an issue. I have a project attribute that is sometimes null. Because of this my custom column below RYG Variance doesn't calculate correctly. If I was using SQL directly I know how to fix this but I cannot seem to fix this in generic inquiry or this query editor. Either solution would work. Any help would be appreciated.
Nevermind. Found isnull in Generic Inquiry. I am used to creating view in SQL server management studio then using ODBC connections to query my views. With some of the limitations I am running into with GI I am starting to use odata so I can achieve what I need in Excel.
Hi Brian,
The formulas available in Generic Inquiry definitely aren't as robust as SQL for sure.
One thing you might consider though when piping the data to Excel via OData is the Power Query formulas that are available for creating calculated columns. They perform a little slower, but they are more advanced than what is available in Generic Inquiry.
Then, if you're using pivot tables, oftentimes you don't even need calculated columns. You can just create measures (using the DAX language) which perform much better and keep your data set a lot smaller.