This seems like it should be easy to do, but for some reason I’m having trouble getting it to work.

In my report I have one data provider where I pull in and . I would like to create several variables that sum over different ranges of . For example, might include only (“6000”,“6780”,“7322”) and might include (“5200”,“2121”,“8620”).

I’ve been trying formulas like
=sum( in inlist (“6000”,“6780”,“7322”))
or
=Sum( where InList (“6000”, “6780”, “7322”))

I searched the boards and came up with this thread and tried these two variables:
= inlist (“6000”, “6780”, “7322”)
and
=Sum( where =“TRUE”)

I’m trying to create some new variables, such as tax and insurance. Tax, insurance, etc… would just be the sum of over certain accounts. I’m having trouble with the “certain accounts” part…

edit:

If I have a table with account numbers, I can calculate the rent, insurance, etc… but the calculations only work inside the table. The problem is that I dont want to access the rent, insurance, etc… value in places outside that table.