More than one value for non-numeric cell - Boolean

CommunityMember115839

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:

 

Action to Import:

 

Error with Import:

 

Unable to display failed rows:

 

"To-Be-Hired - Input" Module:

 

 

 

 

 

CommunityMember115839

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:

 

To-Be-Hired - Input (Target):