0

I am working with SAP BOBI 4.1. My issue is when I export a Webi document to Excel, number fields are formatted as text or preceded by an apostrophe, and dates are represented with only 2 digits for the year.

Formula in SAP Webi:

FormatNumber([obj];"#,#.00")
FormatDate(Max[obj]);"dd-Mmm-yy")

Please advise regarding this. Thank you.

  1. Output from program:
    Output from program

    Expected output:
    Expected output

  2. Output from program:
    Output from program

    Expected output:
    Expected output

Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
tim
  • 13
  • 5

1 Answers1

0

Try this:

ToNumber(FormatNumber([obj];"#,#.00"))
FormatDate(Max[obj]);"dd-Mmm-yyyy")
Toni
  • 1,555
  • 4
  • 15
  • 23
  • Hi @Toni. I try to use integrate your formula. It is fixed but I have a problem now with the decimal. output in program: 1 should be: 1.0000 Formula used: ToNumber(FormatNumber([obj];"#.0000") Please advise regarding this. Thank you. – tim Feb 18 '21 at 06:20