Forum Discussion
Returning true or false based on multiple criteria
I have a table as below called (Results) which has 4 columns [Name], [Age], [Country],[Position] [Client] [Sites] [Country] [Position] Parker 2 UK ...
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 ?
rfigtree
Resolver III
Resolver IIIcalculated column and if statement.
= if(table[position] <= 2 || table[position]>=100, true(),false())