Skip to Content
0

Calculation new varibale after rounding value

Jan 19, 2017 at 04:56 AM

55

avatar image

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.

10 |10000 characters needed characters left characters exceeded

share screenshot..

0

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.

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
AMIT KUMAR
Jan 30, 2017 at 09:33 AM
0

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])

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Amit,

Thank you for your support.

your logic is working fine for my requirement.

Thanks & regards,

Kumar.

1