Hi,
Please could you help me understand which setting i have incorrectly which is populating my actuals in advance in image 1? Image 2 is correct.
Check if your switchover is at Sep 21. Switchover settings are located in versions settings
@lcapon
Are you using IF ELSE statements on TIME dimension? If so then it is worth taking a look at
Misbah
@KirillKuznetsov
Switchover doesn't apply to Actuals. Its the other way around - copying data from Actuals to any other Version member
Thanks - the IF statements in place are an exact replica in both screen shots.
I dont know what else is driving this.
Are you refering to this section?
No, Go to Module blueprint mode and share the formula that is being used in the line item. You don't need to share the numbers related to it - just the formula will be enough
FTE - IF Current Employee THEN 'ES005 Employee Details'.FTE ELSE 0
Mat Leave - IF 'ES005 Employee Details'.'Maternity/Long Term Sick Start' <= END() AND 'ES005 Employee Details'.'Maternity/Long Term Sick End' >= START() THEN 'ES005 Employee Details'.FTE ELSE 0
Head Count - IF Current Employee THEN 1 ELSE 0
Mat Leave Head Count - IF 'ES005 Employee Details'.'Maternity/Long Term Sick Start' <= END() AND 'ES005 Employee Details'.'Maternity/Long Term Sick End' >= START() THEN 1 ELSE 0
Vehicle Allocation - IF 'ES005 Employee Details'.'Car/Van Allocation' THEN 1 * Head Count ELSE 0
Which specific line item were you looking at when you posted the query?
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
