Forum Stats

  • 3,767,857 Users
  • 2,252,726 Discussions
  • 7,874,365 Comments

Discussions

PBCS BSO Business Rule Calculation Issue

Moatasem Shebl
Moatasem Shebl Member Posts: 548 Bronze Badge
edited Sep 27, 2021 5:36PM in Oracle Data Integrator

Hi All,

Kindly I am facing an issue with the below business rule which based on BSO cube :

FIX ( "Analysis",@Relative("All Activities",0),"USD",@Relative("Total Customer",0),@Relative("000",0),@Relative("00",0)@Relative("Total Employee",0),@Relative("Total Location",0),@Relative("YearTotal",0),@Relative("Total Vehicles",0),{Years},"Actual") 

"Gross Profit%"= ("400000" + "500000")/ "400000";

ENDFIX


The Calculation Logic:

Gross Profit %= ("400000" + "500000") / "400000"

The Issue:

When divide the "400000" + "500000" the out put is wrong but the sum is correct


The Account Members Properties:

"400000" : DyCalc

"500000" : DyCalc


Screen shot for the calculation out put : FY19



Thank You

Tagged: