1 Reply Latest reply: Jan 17, 2012 2:59 PM by Erich Shiino RSS

    Conditional Expression

      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.

        • Conditional Expression
          Erich Shiino

          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