I want to create aggregation of Sum(PMO) vs Sum (AOP)

but always return Zero or Infinity,

How to solve this ?

,

"measures": [

{

"uniqueName": "AOP",

"aggregation": "sum"

},

{

"uniqueName": "PMO",

"aggregation": "sum"

},

{

"uniqueName": "STD",

"aggregation": "sum"

},

{

"uniqueName": "STT",

"aggregation": "sum"

},

{

"uniqueName": "PMO vs AOP",

"formula": "sum(\"PMO\") / sum(\"AOP\") * 100",

"individual": true,

"caption": "PMO/AOP"

}

],

Thanks

Thank you for posting your question here.

WebDataRocks returns zero if the first measure of division (sum(\”PMO\”) ) equals zero. In case sum(\”AOP\”) equals zero the infinity will be returned.

Regards,

WebDataRocks Team