Forum Discussion

Sergey's avatar
Sergey
Contributor III
3 years ago

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

Vincent's avatar
Vincent
New Contributor III
2 years ago

Hello,

I have just discovered the power in a quickview of the GetDataCell, as an example I Use : 

GetDataCell((T#2024:S#BUDGET_V3 - T#2023:S#Planning_2023M10) / T#2023:S#Planning_2023M10*1000):Name(Variance)

To obtain a variance.

But in my Quickview I need to have both data with the Comma [0] (my default param) and with percent.

I use the formula for example :

GetDataCell(VariancePercent(T#2024:S#BUDGET_V3,T#2023:S#Planning_2023M10)):Name(Var%)

Is it possible to have the % sign? I found this from the cubeview but don't know the correct syntax :

ReportNoDataNumberFormat = [#,###,0.00;(#,###,0.00);0.00], ShowPercentSign = True

 

Thank you.