Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I currently am working on a financial application where I display a straight table with the balance of each month.
When I select the value Liquide middelen in field BalansOmschrijving2 I get the correct table. The column Saldototaal is the expression SUM (Bedrag * isDebetBoeking) - SUM (Bedrag * isCreditBoeking).
A part of the correct table is:
My selection is:
How do I make the correct set analysis expression for this selection on the calculated field Saldototaal so the table keeps the same when I clear all selections?
The expression that I tried but resulted in a table with the number 0 is:
SUM ({$<BalansOmschrijving2 = {"Liquide.Middelen"}>} (Bedrag * isDebetBoeking) - (Bedrag * isCreditBoeking))
May be this
Sum({$<BalansOmschrijving2 = {"Liquide.Middelen"}>} Bedrag * isDebetBoeking) - Sum({$<BalansOmschrijving2 = {"Liquide.Middelen"}>} Bedrag * isCreditBoeking)
Do you have . between the Liquide and Middelen? Doesn't seem like within the current selection box... so may be you need this
Sum({$<BalansOmschrijving2 = {"Liquide Middelen"}>} Bedrag * isDebetBoeking) - Sum({$<BalansOmschrijving2 = {"Liquide Middelen"}>} Bedrag * isCreditBoeking)
May be this
Sum({$<BalansOmschrijving2 = {"Liquide.Middelen"}>} Bedrag * isDebetBoeking) - Sum({$<BalansOmschrijving2 = {"Liquide.Middelen"}>} Bedrag * isCreditBoeking)
Do you have . between the Liquide and Middelen? Doesn't seem like within the current selection box... so may be you need this
Sum({$<BalansOmschrijving2 = {"Liquide Middelen"}>} Bedrag * isDebetBoeking) - Sum({$<BalansOmschrijving2 = {"Liquide Middelen"}>} Bedrag * isCreditBoeking)