0

I'm using Views Aggregator Plus do aggregate the results of columns. However, I cannot do calculations with the result. This is because the module always does the aggregation last.

The aggregation groups several individual items that are the same and sums the numbers to a total. This then looks like this:

ITEM DEBIT CREDIT
Item A 213 213
Item B 157 722
Item C 489 100

What I want to achieve is that when both debit and credit have a result, they need to be substracted from each other (if debit is larger than credit: debit minus credit, if credit is larger: credit minus debit, if equal: 0).

Giving this:

ITEM DEBIT CREDIT DEBIT RESULT CREDIT RESULT
Item A 213 213 0 0
Item B 157 722 0 565
Item C 489 100 389 0

What solution would be best to tackle this problem? Can I achieve this with twig in views or templating? Or is the only solution to make a module?

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.