The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

royceBPSC's avatar
royceBPSC
New Contributor II
4 years ago
Solved

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
    4 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
4 years ago

Try this

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