Hello,
I am trying to use FIRSTNONBLANK as a function to get the current scenario to match to the current year starting from module dimensioned as month.
SOURCE MODULE
TARGET MODULE
As you can see it's not working, why is it?
Thanks in advance,
Luca
@LucaRicci
Try changing your summary for Year to be FirstNonBlank instead of None.
@rob_marshall tried it, it does not work
Can you please show me the picture of WKK17 Month to Scenario Mapping module as that is where you are needing to change the summary.
@rob_marshall
I have encountered similar problems using the FIRSTNONBLANK function with a time period. What is your actual ask? Do you want the scenario for May 24 in a line item? Create another line item called FNB Scenario, format it with scenario list and write the formula IF ISNOTBLANK(YEAR), THEN Scenario ELSE BLANK and turn the summary on to First non blank. Then you can fetch the scenario of May 24 from All periods using SELECT function.
In the WKK17 module add line item details below:
In the Target module update the formula for Current Scenario to
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
