9 Replies Latest reply: Jul 25, 2016 3:40 PM by Fabio Mazzarelli RSS

    target

    Fabio Mazzarelli

      Hi Community,

      how to prevent calculation of the formula is applied to the total row (red box)

       

      (Sum(DIRFIS)

      + sum({<Commessa = {"=KeepChar(Commessa, '0123456789') * 1 > 10"}>} [TotOreLavorate])

      + sum({<Commessa = {'ASSCLI', 'ASSREM'}>} [TotOreLavorate])

      + sum({<CTRAAN = {'N',""},Commessa = {'ASSTEL'}>} [TotOreLavorate])

      + sum({<CTRAAN = {'T',""},Commessa = {'ASSMOD'}>} [TotOreLavorate]))

      / (85 * (count(MeseEsteso)))Immagine.png