OneStream Community

PeterFu · 04-06-2022

Hi, I am looking for a Business Rule (DataQualityEventhandler) to send e-mail notifications when "Set IC Transaction Status" is used. I know how to send e-mail when the "Set IC Transaction Status" is used. The challenge is to get the comment and othe...

PeterFu

Hi Sabaritha,You can try E#None:Name(" ") in the row you want to show blank (:Name(" ") will make sure no text is shown). Then you can format that row a bit different if you want to show the blank row as a "separator" row.Peter

PeterFu

Hi Tim, If I understand you correctly, you are doing Force Consolidate on the source scenario, but you do a normal Consolidate the first time on the destionation scenario. If that is the case, then I think I make sense that the the normal consolidati...

PeterFu · 05-10-2023

Hi,Go to the Cell format for the column you want to have percent sign. Then scroll down to the formatting for the Report, change ReportUseNumericBinding to True and set ReportNumbericBindingFormat to percent sign. See print screen belw.

PeterFu · 08-12-2022

Hi Carmen, Sorry, I read too quick, I gave you a solution inside of Onestream. However, you will find list of the different Onestream functions in Excel. You get the window with all the fields that you can see in print screen I posted earlier. Peter

PeterFu · 08-12-2022

Hi Carmen, OneStream has a MarketPlace Solution called, Admin Solution Tools. That one contains a Member Formula Builder. See print screen below. Peter

OneStream Community

User Statistics

User Activity

E-mail notification for "Set IC Transaction Status"

Re: Introduce a Blank row in-between members in Tree Expansion

Re: Consolidation slow when after copying from scenario to another

Re: Percentage sign % with parenthesis () is displaying in the data explorer but not in the report.

Re: Is it possible to load data via excel with an XF formula?

Re: Is it possible to load data via excel with an XF formula?