05-18-2022
09:52 AM
- last edited on
05-24-2023
12:28 PM
by
JackLacava
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,
Solved! Go to Solution.
05-18-2022 11:50 AM
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
05-18-2022 11:50 AM
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
05-19-2022 03:53 AM
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,
10-11-2022 05:09 PM
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?