Skip to Content

Calculation new varibale after rounding value

Hi all,

I have an requirement: my source bex query:

from bex report all values are rounded off.

in Webi I want to do calculations on rounded values, please suggest me how to do it.

Thanks & Regards,

Kumar.

Add comment
10|10000 characters needed characters exceeded

  • share screenshot..

  • Hi Amit,

    Actuals Values:

    Plant MTD Values Qtd YTD

    1000 7893.2132 9878.5152 10521.8922

    1001 1893.1567 9678.5112 195431.5999

    From Bex Report Output:

    Plant MTD Values Qtd YTD

    1000 7893 9879 10522

    1001 1893 9679 195432

    In WEBI: when I create a new variable(filed) on top of key figures, it is calculating from actual values.

    Requirement: I want create new variable(filed) with reference of bex result only.

    Example:

    it is calculating: 9878.5152 - 7893.2132 = 1985.302

    I want: 9879 - 7893 = 1986.

    is there any function to achieve this.

    Thanks & Regards,

    Kumar.

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 30, 2017 at 09:33 AM

    follow these steps.

    create variable for MTD & QTD objects in Webi.

    V MTD=round([MTD Values];0)

    V QTD=round([Qtd YTD];0)

    calculation=([V MTD]-[V QTD])

    Add comment
    10|10000 characters needed characters exceeded