Multiple Set Analysis In an Equation

evansabres — Mon, 07 Aug 2017 17:06:08 GMT

Hello I am attempting to structure an equation with a couple of conditions.

The first equation is:

=NUM(Sum({<fmlyGRP= {'Juices'}>}salesTTL), '$##,###.##')

and I want to include this as well:

=NUM(Sum({<Location = {'Food Truck'}>}salesTTL), '$##,###.##')

I am attempting to find the total sales where the 'Location' is equal to 'Food Truck' and the 'fmlyGRP' is equal to 'Juices'

How would this be structured?

Re: Multiple Set Analysis In an Equation

Anonymous — Mon, 07 Aug 2017 17:08:19 GMT

=NUM(Sum({<fmlyGRP= {'Juices'},Location = {'Food Truck'}>}salesTTL), '$##,###.##')