Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to make a chart of Category-Wise Expenses for the Current Month where the Budget exists.
The expression I am using is given below:
Sum ({<CATEGORY_BUDGET={'<>0'}, TRANSACTION_MONTH={Month(Today())}>} TRANSACTION_AMOUNT_OUT)
I am struggling to figure out what is wrong with this expression.
Any help would be greatly appreciated.
Hi,
I believe your expression should be:
Sum ({<CATEGORY_BUDGET-={0}, TRANSACTION_MONTH={$(=month(Today()))} >}TRANSACTION_AMOUNT_OUT)
Your result might still depend on the format of the field Transaction Month. In this case, it should be in the same format of the output of month(Today())
Hope this helps,
Erich
Hi,
I believe your expression should be:
Sum ({<CATEGORY_BUDGET-={0}, TRANSACTION_MONTH={$(=month(Today()))} >}TRANSACTION_AMOUNT_OUT)
Your result might still depend on the format of the field Transaction Month. In this case, it should be in the same format of the output of month(Today())
Hope this helps,
Erich