error in the commentary section of NUX

Options
Jsdeloria21
Jsdeloria21 Member, ALL USERS, Partner Posts: 5 Regular Contributor
in Anaplan Community

Hi Community,

I got this error on the NUX from the client side and it is not quite clear what is the meaning of this message. I hope you can provide some insights on the matter.

Jsdeloria21_0-1657786232050.png

 

Under Incremental NOI with the line item L2 Final Commentary the user is doing a copy and paste a comment drafted in PPT and then pasting it in the line item above.

 

In the source module L2 Final Commentary(text format) has a formula as below:

IF

    ISNOTBLANK(Commentary) AND ITEM('LIS009 REP003 SBU NOI') = 'LIS009 REP003 SBU NOI'.Store GP impact due to change in Sales AND 'SYS003.1: L4 SBU Mapping'.EMEAA Countries?

THEN

    Commentary & " by " & 'Round(Text)' & "m" & " - Due to " & NAME(ITEM('LIS009 REP003 SBU NOI')) & ". " & 'L2 Additional Commentary (Staging)'

ELSE

    IF

        ISNOTBLANK(Commentary) AND ITEM('LIS009 REP003 SBU NOI') = 'LIS009 REP003 SBU NOI'.Store GP impact due to change in Sales AND NOT 'SYS003.1: L4 SBU Mapping'.EMEAA Countries?

    THEN

        Commentary & " by " & 'Round(Text)' & "m" & " - Due to " & NAME(ITEM('LIS009 REP003 SBU NOI')) & ". RB Growth of " & 'RB Growth % (text)' & ". " & 'L2 Additional Commentary (Staging)'

    ELSE

        IF

            ISNOTBLANK(Commentary)

        THEN

            Commentary & " by " & 'Round(Text)' & "m" & " -  Due to " & NAME(ITEM('LIS009 REP003 SBU NOI')) & ". " & 'L2 Additional Commentary (Staging)'

        ELSE

 

         BLANK

 

Is the user not satisfying the condition on the formula that is why the error above is showing up.

 

Any feedback is greatly appreciated.

 

Regards,

 

Tagged:

Categories