LOOKUP to a mapping module using a dimension that is TEXT and not LIST formatted

kmht0307
kmht0307
edited August 29 in Modeling

Hi All,

Trying to make the below formula work, it is BOOLEAN format so expecting a TRUE result in most cases.

'M#5 AA Description Mapping'.Acquisition[LOOKUP: AA Description, LOOKUP: Cohort List]

'M#5 AA Description Mapping' is a module that contains the dimensions AA Description and Cohort List so formulae itself is acceptable in Anaplan without error, however it does not result in a TRUE when it should do.

The only reason I think it does not result in a TRUE is that the AA Description dimension referred to in the formula is formatted as TEXT in the module where this formula is, and the Cohort List is a LIST formatted item.

Is there an easy fix to this formula to get the TRUE result or is it a case of having to create another line item called 'AA Description List' and have this formatted as LIST, and amending the formula to:

'M#5 AA Description Mapping'.Acquisition[LOOKUP: AA Description List, LOOKUP: Cohort List]

Any help would be much appreciated.

Answers

  • darcy.cummins
    darcy.cummins

    If you have a Description list existing. I think performing a FINDITEM to atleast like the list before performing the LOOKUP on the LIST formatted line item should help it.
    TEXT line items can work in the field for a LOOKUP but generally it'll be when looking up a CODE of a list. If you are using a generic text field for LOOKUP but it links to a list the list will make the LOOKUP perform better.

Categories