The formula we currently use to list filters lists only the worksheet filters. I would like to combine both the WORKBOOK and WORKSHEET list filter formulas into one but when I try to, it includes all of the line breaks even when there is no more filt...
When adding attribute totals to the planning view, the total row has labels of (Total). Is there anyway to change this literal? It is very confusing to see every total row look the same with respect to labeling.
I have a CI-DS task where I have $G_FILE_NAME as a global variable. When running the job (as Run Now), I chose to enter an alternate file name than was set up with the task (using the Current Value (for this run only) functionality). But, when the ta...
Since upgrading to version 2305, when creating a new planning view and setting the formatting on a Total Member, it is not applying the formatting to the entire row.
What you provided did help in verifying that the global variable override was working. The issue was that when the source file was added to the data flow, the actual file name was used, not the global variable ($g_file_name).
I was able to put together a formula that works to list both workbook and worksheet filters without the extra line feeds. This is very basic and can be enhanced as needed.= "WORKBOOK Filters:" & CHAR(10) & IFERROR(@INDEX(SOP_WB_Filter,1) & CHAR(10),"...
I found a work-around for this issue. For the attribute that you are Totaling, you must add a line in the formatting sheet where the attribute value = (Total) and format that as you did the Total Member.
I have found this this ONLY happens when I use "Periods and Total" to have a Total Column. If I change that to just Periods, the formatting on the Total row is done correctly.Any possible solutions to this issue?
Thank you for pointing to me to that documentation but it doesn't explain which API is used to call the application template. Can you be more specific (or give an example of the API call)?Thank you.
