Forum Discussion
Returning true or false based on multiple criteria
What is the result you want? If my understanding is incorrect, please correct me.
Your expectation result should be :
After summarize column [Client], [Sites], [Country] ,
if sum ( [Position] ) <= 2 and sum[position]>=100 then Ture else Falseor : if avg ( [Position] ) <= 2 and avg [position]>=100 then Ture else False
Which kind of aggregation is what you want ?
Sorry columns are [Client], [Sites], [Country],[Position]
Resolver IVWhat is the result you want? If my understanding is incorrect, please correct me.
Your expectation result should be :
After summarize column [Client], [Sites], [Country] ,
if sum ( [Position] ) <= 2 and sum[position]>=100 then Ture else False
or : if avg ( [Position] ) <= 2 and avg [position]>=100 then Ture else False
Which kind of aggregation is what you want ?