Skip to Content
0
Jul 29, 2016 at 12:25 PM

Bex query calculations

36 Views

Hello Friends,

I have a BEx query in the following format:

WBS Emp cost WBS Cost Revenue

101 10 5

101 20 8

101 10 6

I want the revenue as per the below formula for a particular WBS 101.

Revenue = (Emp Cost / Total Emp Cost ) * WBS Cost

Could anyone please advise me?

Thanks & regards,

Rathinakumar