XFCell Calculation

Sergey
Contributor II

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 retrieve data for specific Dimension Members.  Culture User is based on the computer’s Windows settings and the User settings.
XFCell(Memberscript, Culture=User, NumberFormat=N3,DisplayNoDataAsZero=True, Scale=3, FlipSign=True, ShowPercentageSign=False)

 Unfortunalety it does not give much details as to what the "memberscript" should be ...

So far, I have 2 parameters build up with XFCell, that are giving me the right values. But Now that I simply need to calculate the ratio between those value, and get this ratio back in the word document, I'm a little bit stuck ...

 

Regards,

1 ACCEPTED SOLUTION

ChristianW
Valued Contributor

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

View solution in original post

3 REPLIES 3

ChristianW
Valued Contributor

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

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,

PFowler
New Contributor

Returning back to this topic can I get an example of using this expression to retrieve some type of data not really using calculations on an extendable doc?