topic Re: Set Analysis expression (nested?) help in App Development

Set Analysis expression (nested?) help

Anonymous — Wed, 31 Aug 2016 15:27:04 GMT

I need a sum of sales from associates whose SalesType is 'OutsideSales' **AND** if they have more than 10 rows of data.

SELECT

SUM(Sales)

FROM table

WHERE SalesType = 'OutsideSales'

HAVING COUNT(*) > 10

I have tried something like this...Not working:

Sum({<SalesAssociate = {'$(=Count({<SalesType = {'OutsideSales'}>} SalesId) > 0)'}>}Sales)

Gysbert_Wassenaar — Wed, 31 Aug 2016 16:18:52 GMT

Just in case you're trying this in the script: set analysis cannot be used in the script.

But if you're trying to use the expression you posted in a chart then try this one:

Sum({<SalesAssociate = {"=Count({<SalesType = {'OutsideSales'}>} SalesId) > 10"}>}Sales)

Anonymous — Wed, 31 Aug 2016 16:46:13 GMT

Works great. Thank you!