Formula issue

[rickdunna]

BO 6.5.1

This is what I am doing:

=<Total Amount> where (<Account> = "2342") This Works!

My problem though is I have multiple accounts I need to check for so if I add to this query in any way it will not work. It comes back incompatable data or syntax error.

I have tried InList, In, or, and any thing else I can think of.

Any help would be appreciated.

Thanks Rick.

 

[skrandel]

The WHERE function in BO cannot accept anything other than a single constant and an '='. Seems like perhaps you could use a grouped variable to do the same thing. Or perhaps even an if-then-else.

Steve Krandel
Intuit

 

[rickdunna]

It worked!

Thanks for your help.