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 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

 

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 %)

1 Reply

  • 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 %)