1 Reply Latest reply on Oct 26, 2016 9:27 AM by Narasimharao Thurai

    Adding Sub -Totals Accross the cells

    Narasimharao Thurai

      Hi All,

       

      PFA for Sample data. In that Red color marked is what i need achieve .

       

      Condition is

       

      IF Amount 2 > = 0 Then show Max of c +  Max(Amount 3) (Total using Sum) Else Show Max(Amount 3) (Total using Sum) END.

       

      Please kindly adivice how to sum 2 totals across cell (only totals) not values . i need to capture the total values and sum up in grand total row. please look into the spread sheet for example.

       

       

      Thanks,

      Rao

                                                                                    

      NameSet offAmount 2Amount 3Total Limit
      xon 030
      050
      Total08080
      offHidden
      Hidden
      Total Max of cBlank
      Grand Total Max of c8080+ max of c)