Calculate task budget variance | Community
Skip to main content
A
AndyHeller
Level 1
January 27, 2026
Solved

Calculate task budget variance

  • January 27, 2026
  • 2 replies
  • 20 views

Hello, 

I am trying to build a report that shows planned v actual hours on a milestone.  I built a task report.  Am trying to figure out how to create a variance column that calculates the difference between actual and planned hours to make this easier for the stakeholders to read.  I had a formula that was giving me a blank column.  simplifying it, i just put a column in there, and its giving me nulls.  See screenshot.   Can anyone advise me on what I need to do, or where there is documentation that explains how to do this?  

AI got me this far and suggested using text mode, but there’s something I am missing here and I can’t figure it out on my own.  Thanks in advance!

 

Best answer by KellieGardner

Without seeing your text mode it’s hard to know what to fix. 

 

This is the formula I use.

 

aggregator.function=SUM
aggregator.valueexpression=SUB({actualWork}, {workRequired})
aggregator.valueformat=compound
displayname=Hours Variance
linkedname=direct
textmode=true
valueexpression=SUB({actualWork}, {workRequired})/60
valueformat=customNumberAsString

2 replies

kautuk_sahni
Community Manager
kautuk_sahniCommunity Manager
Community Manager
February 2, 2026

 ​@KatherineLa ​@Rafal_Bainie ​@RowvillBh1 ​@AmyReilly ​@KIMBERLYREA ​@KellieGardner 

Tagging you to see if you might want to share any best practices or insights on this topic. Your expertise would be greatly appreciated, thank you!

Kautuk Sahni
KellieGardner
Community Advisor
KellieGardnerCommunity AdvisorAccepted solution
Community Advisor
February 2, 2026

Without seeing your text mode it’s hard to know what to fix. 

 

This is the formula I use.

 

aggregator.function=SUM
aggregator.valueexpression=SUB({actualWork}, {workRequired})
aggregator.valueformat=compound
displayname=Hours Variance
linkedname=direct
textmode=true
valueexpression=SUB({actualWork}, {workRequired})/60
valueformat=customNumberAsString
    Terms & ConditionsAccessibility statement

    Loading footer...