Conditional Expression

[vksthkkr]

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.

[erichshiino · Accepted solution]

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