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