Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How do we use and condition in set analysis?
I want to display the sum(Value) where Category='A', Type='B', Place not equal to 'C' and Year>2013.
Sum({<Category={'A'}, Type={'B'}, Place -={'C'}, Year={'>2013'}>}Value)
sum({<Category={'A'}, Type={'B'}, Place-={'C'}, Year={">2013"}>} Value)
SUM({$<Category = {'A'}, Type = {'B'}, Place -= {'C'}, Year = {'>2013'}>}Value)
Or
SUM({$<Category = {'A'}, Type = {'B'}, Place -= {'C'}, Year = {'>$(=Year(Today())-1)'}>}Value)
Try this
Sum({<Category={'A'},Type={'B'},Place-={'C'},Year={'>2013'}>}Value)
sum( {$<Category={A}, Type={B}, Place=-{C}, Year = {“>2013”}>} Value)
or
sum( {$<Category={A}, Type={B}, Place-={C}, Year = {“>2013”}>} Value)
no need to quote
Hi
I find this online tool great for set analysis, and really helps you understand how to build it.