Invalid formula error when attempting ALM sync

Highlighted
Occasional Contributor

Invalid formula error when attempting ALM sync

This item has been identified as a known issue, please contact Support at support@anaplan.com if you encounter this.

A workaround is provided until the issue is officially fixed.

Receiving an error when attempting an ALM sync:

An internal error occurred while preparing the 
structural changes for synchronization. Reason for error:
The formula for Module.LineItem is invalid:
Module.LineItem = Module.LineItem[LOOKUP: Module.LineItem]

The error is thrown if, when using a lookup formula, the following occurs:

  • In the target model, the mapping line item has a month timescale
  • In the target model, the line item containing the lookup formula has a year timescale
  • In the source model, the formula in the mapping line item is edited

To work around the issue, for the line item containing the lookup formula, please follow these steps:

  1. Delete the formula, after copying it to a text editor
  2. Create a revision tag and sync
  3. Re-add the formula
  4. Create a revision tag and sync

Internal Reference: ALM-1282

Message 1 of 1