Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello together,
I am using the below expression.
AGGR(If(Count([Text1])>1,'Match'),[Text1])
It works fine
Now I want to add the same with Text2 using +.
It shows OK but the expression does not work.
AGGR(If(Count([Text1])>1,'Match'),[Text1])
+
AGGR(If(Count([Text2])>1,'Match'),[Text2])
Thanks in advance.
Or you can try this-
sum(aggr(If(Count([Text1])>1 or Count([Text2])>1,'Match'),[Text1],[Text2] ))
Could you please post your app, or at least the data you are using and explain what you mean by: "It shows OK but the expression does not work".
If I just use one of both it brings me some data with the equal text.
AGGR(If(Count([Text1])>1,'Match'),[Text1])
+
AGGR(If(Count([Text2])>1,'Match'),[Text2])
Please post your data in an Excel spreadsheet or other (removing anything confidential) so that I can look into it.
HI
AGGR(If(Count([Text1])>1,'Match'),[Text1])
+
AGGR(If(Count([Text2])>1,'Match'),[Text2])
-- It means, you are adding Match + Match , it doesn't possible to add Text .
I think, you want to display Match when Text1 or Text2 is greater than 1? if so, try like below
If(Count(Text1) > 1 or Count(Text2)> 1, 'Match'))
Or you can try this-
sum(aggr(If(Count([Text1])>1 or Count([Text2])>1,'Match'),[Text1],[Text2] ))
Are you trying to do this?
Aggr(If(Count([Text1]) > 1, 'Match Text1'), [Text1])
& ' and ' &
Aggr(If(Count([Text2]) > 1, 'Match Text2'), [Text2])
This worked fine, thanks.
aggr(If(Count([Text1])>1 or Count([Text2])>1,'Match'),[Text1],[Text2] ))