Skip to main content
R
royceBPSC
April 4, 2022
Solved

Variance Formula

  • April 4, 2022
  • 1 reply
  • 0 views

Hi, sorry for such a small issue but hoping to get a quick second look. I input the following to calculate BW percent but the following screenshot with the error keeps coming up, despite the comma I put in. Would anyone know what could be wrong with the syntax? 

GetDataCell("BWPercent(S#Working:V#QTD:T#QuarterNext1(|CVTime|),S#Budget:V#QTD:T#QuarterNext1(|CVTime|))"):Name(Var %)

royceBPSC_0-1649099190577.png

Thank you

 

Best answer by Sai_Maganti

Try this

GetDataCell("BWPercent(S#Working:V#QTD:T#[QuarterNext1(|CVTime|)],S#Budget:V#QTD:T#[QuarterNext1(|CVTime|)])"):Name(Var %)

1 reply

S
Sai_MagantiAnswer
April 4, 2022

Try this

GetDataCell("BWPercent(S#Working:V#QTD:T#[QuarterNext1(|CVTime|)],S#Budget:V#QTD:T#[QuarterNext1(|CVTime|)])"):Name(Var %)

Terms & ConditionsAccessibility statement