Hello all,
How can I get the month where the switchover week-end falls under? I've tried several things, not getting the desired output, yet. Thanks!
@sosunkwo
Great question...Is it the Current Version or just any version with a switchover?
If it is for just the Current Version, you can change the formula scope to Current Version, but if you want all of them, you can do this:
Create a module dimensionalized by Time and Versions, with one line item. I have it defined as Date, but it could be anything. Format should be Period with the summary being either First Non Blank or Last Non Blank. The formula should be: IF ISBLANK(PREVIOUS(Date)) THEN ITEM(Time) ELSE PREVIOUS(Date)
Then, the fun trick is to change the Formula Scope to All Versions except Actual.
Hope this helps,
Rob
Hi ALL, I'm using Product Category, Product Line, and Budget Type to generate a unique Code for a list. The display string is generated as: Product Category & "_" & Budget Type & "_" & Product Line. The Code is currently generated using: LEFT(Display String, 60) The issue is that Product Category and Product Line contains…
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New → New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, no…
Why in my model output is blank, after send explainability data.
