XFDoc - PPT dynamic calcs
Hello, Is it possible to add dynamic calcs (UD8 member) into an XF doc powerpoint? I am trying to create an XFCELL that uses a variance member in UD8. However, I keep getting 0 as the value. Also, ...
Forum Discussion
Thanks! Is there a way to pass parameters into it as well? I can have parameters stand alone in the ppt, but not within the xfcell. Your copying and pasting method worked for getting the UD8 member to return, but if I replace let's say the time member with a parameter it only returns the XFCELL string like so: XFCell(Cb#ProtoCube:E#Group:C#Local:S#Aug 07_12 FCST:T#2023M5:V#Periodic:A#AEBITDA:F#EndBal:O#Top:I#Top:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#None:U7#Top:U8#ActualvBudget, Culture=User, NumberFormat=N0, DisplayNoDataAsZero=True, Scale=0, FlipSign=False, ShowPercentSign=False, UseApostrophePrefix=False)
No problem! Passing a parameter into the XF Cell is possible as well. In your example, you would insert your parameter name into the XF Cell after the "T#". Remember to use the correct syntax for parameters (with pipes & exclamation points):
XFCell(Cb#ProtoCube:E#Group:C#Local:S#Aug 07_12 FCST:T#|!your_parameter_name!|:V#Periodic:A#AEBITDA:F#EndBal:O#Top:I#Top:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#None:U7#Top:U8#ActualvBudget, Culture=User, NumberFormat=N0, DisplayNoDataAsZero=True, Scale=0, FlipSign=False, ShowPercentSign=False, UseApostrophePrefix=False)
When you process and open the document from the file explorer, you will be prompted with the parameter in the XF Cell.
Once a selection is made, the PPT will open based on your selection.