1 Reply Latest reply on Nov 22, 2012 11:31 AM by user12017723

    BI Publisher Excel Templates: Formatting large number?


      I am using this statemnt in XDO_METADATA sheet:
      XDO_?SUM_BONUS_GESAMT?     <?sum(current()/G_2/G_3/BP[../SPALTE/text() = '3'])?>

      In the Excel output I get this: 1,2522883E7 with the warning 'Number stored as text'
      While I am expecting this: 12522883
      It only happens with large numbers.

      If I just reference a field in the template with this number it is displayed cotrrectly in the output.

      Is it possible to prevent this behaviour?

      Thanks a lot