Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
=NUM(Sum({<fmlyGRP= {'Juices'},Location = {'Food Truck'}>}salesTTL), '$##,###.##')
=NUM(Sum({<fmlyGRP= {'Juices'},Location = {'Food Truck'}>}salesTTL), '$##,###.##')