4 Replies Latest reply: Jul 31, 2013 1:12 PM by user10729693 RSS

    Hiding a column if the column total is 0(zero)

    user10729693

      Hi,

       

      I am trying to hide the entire column if the column total is 0.

       

      Template sample:

      Num

      IF Amt1 end if

      Amt2

      IF Amt3 end if

      F NUM

      IF $0.00 end if

      $0.00

      IF $0.00 end if E

      Totals

      IF $0.00 end if

      $0.00

      IF $0.00 end if

       

      Sample Data:

       

      Num

      Amt1

      Amt2

      Amt3

      001

      108.25

      28.00

      0.00

      0020445.000.00
      003100.12472.000.00
      004145.00872.000.00
      00516.3025.320.00

       

      I am using the below expressions which is not working.

      <?if@column:sum(amt1)!=0?> <?amt1?> <?end if?>

      <?if@column:sum(amt3)!=0?> <?amt3?> <?end if?>

       

      I would like to hide the entire Amt3 cloumn and leave the '0' at amt1 as it is. Any help would be much appreciated.