Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everybody,
I have the following expression
Only( {$<[Review Area Name]={'Overall'},[Product Group]={'All Products'}>},[Client Name])
I want to include if(Count([Review Area General Comments]>1 in the above expression
I tried something like this
Only( {$<[Review Area Name]={'Overall'},[Product Group]={'All Products'},[Review Area General Comments]={"=count([Review Area General Comments]>1"}>}[Client Name])
which is not giving me the result that is required .
Help me how to include this in the set analysis expression
Thanks,
Venkata
Maybe like:
Only({$<[Review Area Name]={'Overall'},[Product Group]={'All Products'},[Client Name]={"=count([Review Area General Comments])>1"}>} [Client Name])
Nope its not working .
Actually i need Client name
if ( Review Area Name = ' Overall' And Product Group = 'All Products' And count(Review Area General Comments>1),
Client Name
this is the entire logic that needs to be built .where if there are comments >1,and those conditions satisfy then client name should be the result .
=Only({<[Review Area Name] = {'Overall'}, [Product Group] = {'All Products'}>}IF(Aggr(COUNT([Review Area General Comments])>1,[Client Name]),[Client Name]))
In case if you have more than one Client Name satisfying your condition... you can use...
=Concat({<[Review Area Name] = {'Overall'}, [Product Group] = {'All Products'}>}IF(Aggr(COUNT([Review Area General Comments])>1,[Client Name]),[Client Name]),', ')
Set Analysis
=Concat({<[Review Area Name] = {'Overall'}, [Product Group] = {'All Products'}, [Client Name] = {"=Aggr(COUNT([Review Area General Comments]),[Client Name])>1"}>} DISTINCT [Client Name],', ')
or
=Only({<[Review Area Name] = {'Overall'}, [Product Group] = {'All Products'}, [Client Name] = {"=Aggr(COUNT([Review Area General Comments]),[Client Name])>1"}>} DISTINCT [Client Name])
The comments should not be blank and if comments have count which is greater than 1 than client should appear
This is what I have written. are my codes not working?