2 Replies Latest reply on Jun 17, 2016 7:36 AM by alison.wells

    Hiding objects based on summary results

    Stu412

      Title

      Hiding objects based on summary results

      Post

      I have a summary report which contains columns of data.  Most are complete but some columns are empty, but required for comparison (simply to show they're empty)

      On my list layout, I'm using summary calculations to show the totals of the columns with line objects to underline these totals.  I am trying to hide these totals where there are no figures at all in the columns.  I've met with mixed success.

      I can hide them if 'Value2014'=0 (this is one of the columns on the report and a field on the table) .  However, what I've noticed is if the final value in the sorted range is empty, or zero, FM hides the objects.

      I then thought about hiding the lines based on the summary figures, but that's not worked either.

      Any ideas on this one?

      Thanks