Forum Discussion

royceBPSC's avatar
royceBPSC
New Contributor II
3 years ago

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 ...
Finance
  • Sai_Maganti's avatar
    Sai_Maganti
    3 years ago

    Try this

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

Sai_Maganti's avatar
Sai_Maganti
Contributor II
3 years ago

Try this

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