Skip to main content
Question

Using Functions to calculate Financials over a Given Time period

  • 4 June 2024
  • 1 reply
  • 15 views

Hello,

 

I’m currently using the GetTotalFinancialSummaryForGivenPeriod function to calculate a Project Budget for a selected time period (PlannedBudget), which is working great & returns correctly for the period I’ve specified in the function.

However is there a way or another function to then split this into Labor & Non-Labor? i.e. if the total returned is $50k for a given period in my function above, I want this to return for example $25k Labor, $25k Non-Labor. 

I’ve tried using both BudgetCostLR & BudgetCostNLR in a range of different functions but it does not work… any suggestions or ideas would be great. 

Thank you!

Hi Sean

Thank you for your query. This is a very valid point you’re raising.

The best way at this point to get & view the information as you described would be via crosstab reports in which you would specify the date range and where you can then get the distinctive amounts per Labor and Non Labor.

Reply


Terms of UseCookie settings