topic Re: Set Analysis Where Sum >0 in App Development

Set Analysis Where Sum >0

m_perreault — Wed, 06 Jun 2018 13:34:48 GMT

Hi All,

I have the following table and I would like to use set analysis to include only ID's where all of the measures are > 0. Does anyone have any suggestions?

ID Measure 1 Measure 2 Measure 3

1 10 0 5

2 5 5 5

3 0 3 6

4 10 15 20

So ideally my resulting table would be

ID Measure 1 Measure 2 Measure 3

2 5 5 5

4 10 15 20

Thanks!

Mark

Re: Set Analysis Where Sum >0

Chanty4u — Wed, 06 Jun 2018 13:37:58 GMT

try this

Count({< Field= {"=Sum(Sales) > 0"} >} DISTINCT Field)

Re: Set Analysis Where Sum >0

YoussefBelloum — Wed, 06 Jun 2018 13:39:00 GMT

Hi,

the set analysis part on your expression(s) would be this:

{<ID={"=Sum(MeasureX)>0"}>}

Re: Set Analysis Where Sum >0

sunny_talwar — Wed, 06 Jun 2018 13:41:21 GMT

May be this

Sum({<ID = {"=RangeMin(Sum([Measure 1]), Sum([Measure 2]), Sum([Measure 3])) > 0"}>}[Measure 1])

Sum({<ID = {"=RangeMin(Sum([Measure 1]), Sum([Measure 2]), Sum([Measure 3])) > 0"}>}[Measure 2])

Sum({<ID = {"=RangeMin(Sum([Measure 1]), Sum([Measure 2]), Sum([Measure 3])) > 0"}>}[Measure 3])