How to sum values with condition in current group bi publisher

Emanaly

Summary

How to sum values with condition in current group bi publisher

Content

what is the correct syntax for this :

<?sum(current-group()/SUM_COS_COSTED_VALUE_[../DEBIT_OR_CREDIT='C']) -  SUM_COS_COSTED_VALUE_[../DEBIT_OR_CREDIT='D'] )?>

 

I want for each CAK_SEGMENT2_ to sum the field (SUM_COS_COSTED_VALUE_) where DEBIT_OR_CREDIT='C' - (SUM_COS_COSTED_VALUE_) where DEBIT_OR_CREDIT='D'

 

I can get the sum of debits this way <?sum(SUM_COS_COSTED_VALUE_[../DEBIT_OR_CREDIT='D'])?> , similarly, the sum of credits, but when I try to get this for each CAK_SEGMENT2_  I get error unknown expression.

YGUTTIKONDA

Pl check the following blog post for a detailed example

https://blogs.oracle.com/xmlpublisher/conditional-totals