Skip to Content
avatar image
Poojitha Sukumaran

Convert numbers to sum in Webi

Nov 22, 2017 at 05:01 PM | 56 Views

Hi All,

I have a requirement to show the sum of numbers in the form of time.

Eg:

Sum should be 7 but it is showing as 6.20. Can someone please suggest on this?

Thanks

capture.png (9.1 kB)
SAP BusinessObjects - Web Intelligence (WebI)
webi 4.2
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    AMIT KUMAR
    Nov 22, 2017 at 06:03 PM

    use this in the total row.

    First i am converting number to string data type to exract hour and mintues in seprate.After that i have converted mintues to hour and added.

    =Sum(ToNumber(Substr(FormatNumber([TIME];"0.00");1;Pos(FormatNumber([TIME];"0.00");".")-1))+ToNumber(Right(FormatNumber([TIME];"0.00");2);"00")/60)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    AMIT KUMAR
    Nov 22, 2017 at 05:05 PM

    Based on the screenshot total of all entries is 6.2.How are you expecting it should be 7?

    time column is based on variable or direct object? in case of variable then use foreach () in sum row and add dimensions which needs to be there.

    Add comment
    10|10000 characters needed characters exceeded