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

Sergey's avatar
Sergey
Icon for OneStream Employee rankOneStream Employee
4 years ago
Solved

XFCell Calculation

Dear community,   I am trying to calculate 2 values directly in my XF Document. There is a part in the online documentation that is saying : Include Member Scripts in XFCells in order to retr...
Excel Add In
  • ChristianW's avatar
    ChristianW
    4 years ago

    Hi Sergey

    Memberscript is just another word for POV.

    If you want to run a calculation, you have to use a business rule within the XFCell call.

    BR#[YourBrName, FunctionName=Sum, PoV1=Value1, PoV2=Value2]

    Cheers

    Christian

Sergey's avatar
Sergey
Icon for OneStream Employee rankOneStream Employee
4 years ago

Thanks Christian,

Indeed only the Business Rule was able to serve this need 🙂 But it really works like a charm in the XF Word document !

Regards,