How can I filter ‘Amount’ column, which is a number formatted column, so that it takes only negative numbers?
GL.Amount[by sum:GL.Month,GL.Account, GL.'Department Pigment'][Filter : Account.'Account Code'="11010"]
In the above formula, I am summing up transaction amounts from “GL” Transaction List by Month, Account, and Department (which are all dimensions). However, I also want Pigment to take only negative amounts. I tried to paste [GL.Amount < 0] within the filter, but it keeps telling me that the system cannot do that, as GL.Amount is not a dimension but number.
Best answer by francoisView original