royceBPSC
3 years agoNew Contributor II
Variance Formula
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 %)
Thank you
Try this
GetDataCell("BWPercent(S#Working:V#QTD:T#[QuarterNext1(|CVTime|)],S#Budget:V#QTD:T#[QuarterNext1(|CVTime|)])"):Name(Var %)