1 Reply Latest reply: Apr 7, 2016 8:32 AM by Zhihong He RSS

    using formula in nprinting

    Zhihong He

      Hi, all,

       

      I am creating a nprinting excel template (see below 1.template).

      I use a excel formula in column E. And this only works sometime.

      The search area "A4:B16" in the template changes in the generated report. The "A" part is correct, and do follow a rule,

      but the "B" part changes "random". Half of the rows cover the table, half of it dose not. I say it is random, because I can not see the rule for the "B" part.  It can jump like in my example below from "B16" to "B25" (2. generated report). And for different reports, sometimes,  if the table has less rows, then first row of the  "B" part can cover the whole table. But if the table is bigger, the "B" part for the first few rows can not cover the whole table, then it can not get the value of the "Total" column.

       

      As I use the row number of the <Name_Level> and </Name_Level>  in the template. I thought the "B" part should be the end of the report, but it seems not the case. Dose any one has any idea?

       

      Thanks very much

      Zhihong

       

      1. template:

      ABCDE
      1
      2Report Time:
      3
      4<Name_Level>
      5
      6<Name>
      7
      8
      9Report 1
      10C1C2C3C4New Column
      11<CH23_Level>
      12<C1><C2><C3>

      <C4>

      =B12/VLOOLUP("Total";A4:B16;2;FALSE)
      13</CH23_Level>
      14Total=SUM(B11:B13)
      =SUM(C11:C13)
      15
      16</Name_Level>

       

       

      2. generated report:

      ABCDE
      1
      2Report Time:
      3
      4<Name_Level>
      5
      6<Name>
      7
      8
      9Report 1
      10C1C2C3C4New Column
      12Name121a=B12/VLOOLUP("Total";A12:B16;2;FALSE)
      13Name232b=B13/VLOOLUP("Total";A13:B16;2;FALSE)
      14Name343c=B14/VLOOLUP("Total";A14:B25;2;FALSE)
      15Name453d=B14/VLOOLUP("Total";A15:B26;2;FALSE)
      16Name565e=B16/VLOOLUP("Total";A16:B27;2;FALSE)
      17Total2014f
      18
      20</Name_Level>
        • Re: using formula in nprinting
          Zhihong He

          I finally make it work after use big enough value for "B" part in the template, like "A4:B300", but not use the row number of  <Name_Level> and </Name_Level>  in the template. As my VLOOKUP() formula only need to use the value from the first match, so it dose matter if there are multiple match, so I do not need to control the search area of VLOOKUP(). But still have no idea the rule for the "B" part here.

           

          Zhihong