cancel
Showing results for 
Search instead for 
Did you mean: 

Calculation new varibale after rounding value

former_member267533
Participant
0 Kudos

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.

amitrathi239
Active Contributor
0 Kudos

share screenshot..

former_member267533
Participant
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

amitrathi239
Active Contributor
0 Kudos

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

former_member267533
Participant

Hi Amit,

Thank you for your support.

your logic is working fine for my requirement.

Thanks & regards,

Kumar.

Answers (0)