Skip to main content
Solved

RevisionID on the BudgetForecast screen wont appear on a GI


Forum|alt.badge.img
  • Jr Varsity III
  • 39 replies

We are using Velixo to create a report showing current percent complete and forecasting the percent complete per month till the end of the project.  The problem I have is when pulling the Budget Forecast into the spreadsheet I need the RevisionID of last update.  I have pulled that field into the GI but it wont show up.  It doesnt even show up, but its on the results grid.  Any idea how I could get this number to show?  

Best answer by Gabriel Michaud

Hi Michael,

I just created a test GI that returns the most recent forecast revision ID by project and I am able to retrieve it just fine from Excel:

I used the self-join trick that I described in this post to get the most recent revision based on the LastModifiedDateTime; if you want to look at the Revision ID instead you can just use a simple Group By with a MAX aggregate on the Revision ID.

In Excel, I would recommend using =GILOOKUP() instead of =GI() for this particular use case. You’ll first need to setup the keys in the Workbook Options like that:

Then, you can retrieve the most recent revision for a given project this way: =GILOOKUP("Demo", "ForecastLastRevision","Revision",<project or reference to a cell>). Here’s a sample in a real report:

Do not hesitate to reply to this or to contact support@velixo.com if you need additional assistance with this request.

View original
Did this topic help you find an answer to your question?

2 replies

Gabriel Michaud
Captain II
Forum|alt.badge.img+10

Hi Michael,

I just created a test GI that returns the most recent forecast revision ID by project and I am able to retrieve it just fine from Excel:

I used the self-join trick that I described in this post to get the most recent revision based on the LastModifiedDateTime; if you want to look at the Revision ID instead you can just use a simple Group By with a MAX aggregate on the Revision ID.

In Excel, I would recommend using =GILOOKUP() instead of =GI() for this particular use case. You’ll first need to setup the keys in the Workbook Options like that:

Then, you can retrieve the most recent revision for a given project this way: =GILOOKUP("Demo", "ForecastLastRevision","Revision",<project or reference to a cell>). Here’s a sample in a real report:

Do not hesitate to reply to this or to contact support@velixo.com if you need additional assistance with this request.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 39 replies
  • May 25, 2021

Thank you Gabriel.  That worked perfectly.  I appreciate the attention.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings