8 Replies Latest reply: Nov 21, 2017 5:22 PM by Effie Theodorou RSS

    Repeat calculation on multiple rows

    Effie Theodorou

      Hi hoping someone can help me with my dilemma.  I have created an excel report in NPrinting, which is using level to get a calculated column, which also uses Entity which brings in multiple rows.  One section is for budgets but another section will be filled in manually when the recipients receive the report, however I need to subtract the multiple rows to obtain a variance between the budgets and the manually inputting forecast figure.

      Ive attached a basic image of the report to try and show what I need to happen.

       

      Would anyone know if this is possible?  Putting in a basic formula in the Entity cell does not carry over to the other cells.

       

      Thanks

      Effie