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.
