More than one value for non-numeric cell - Boolean

Options
CommunityMember115839
CommunityMember115839 Member, ALL USERS Posts: 2 New Contributor
in Extensibility

Hello, 

 

I have a input module published to a dashboard that allows planners to enter new headcount for their departments (Planner Dashboard TBH Input - DB View). I import this data into another module that doesn't have the department dimension (To-Be-Hired - Input). The purpose of the dashboard module is to prevent planners from overriding and seeing each other's inputs. I have a boolean that determines if the the new position is a backfill. When I import into the "To-Be-Hired - Input" module, I get the "More than one value for non-numeric cell" error on only some of my boolean items. Anaplan will not display what rows are causing the error. While the import appears to work each time, my planners get confused seeing an error message, and reach out to see if their changes went through. I would greatly appreciate any assistance!

 

"Planner Dashboard TBH Input - DB View" Module:

CommunityMember115839_0-1622812024902.png

 

Action to Import:

CommunityMember115839_1-1622812110449.png

 

Error with Import:

CommunityMember115839_2-1622812191089.png

 

Unable to display failed rows:

CommunityMember115839_3-1622812224597.png

 

"To-Be-Hired - Input" Module:

CommunityMember115839_4-1622812300115.png

 

 

 

 

 

Tagged:

Comments

  • CommunityMember115839
    CommunityMember115839 Member, ALL USERS Posts: 2 New Contributor

    Vinayvm, 

     

    Thank you for the quick reply. I made changes to the saved view to eliminate the summary items hoping that was the cause. It did not fix my problem. If I have no subsidiary views in either module, why would just the boolean be giving me this error? I set the formula to FALSE to make sure everything is cleared out of the boolean, even though I do have a clear action within the process. Adding the department dimension to the target module is not really an option due to sparsity concerns. I've included screenshots of both module's blueprint views as well.

     

    Planner Dashboard TBH Input:

    CommunityMember115839_0-1622828625177.png

     

    To-Be-Hired - Input (Target):

    CommunityMember115839_1-1622828688922.png

     

Categories