In CalPlan, Enter Data in Form is there a way I can remove all of the rows with no data or zeros?


When working in CalPlan on the Enter Data in Form tab you can hide rows with no data, with zeros or both.

From the row label, right-click and select Filter and choose one of the three options

  • Hide rows with no data
  • Hide rows with zeros
  • Hide rows with zeros and no data

To unhide the rows once hidden, from the row label, right-click and select Filter -> Show rows with zeros and no data