We have updated WebDataRocks EULA, effective as of April 18, 2024. Learn more about what's changed.

How to create custom aggregation of Measure ?

Answered

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

Attachments:
wdr.png

1 answer

WebDataRocks Team WebDataRocks October 22, 2019

Hello Eko,
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