Trying to retrieve number from AccountingPeriod to use in Formulas in Financial Reporting Web Studio
Summary:
We are facing a challenge where we need to calculate a specific value using the AccountingPeriod number. However, the AccountingPeriod in the GL cube is represented as "P9-23", and we specifically require the number 9 from this period to be used in the calculation. We have attempted to retrieve the period number using conditional formatting. Unfortunately, the mathematical functions in FRS are unable to convert the text representation to a numerical value.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0