topic Add Or function in expression in App Development

Add Or function in expression

Daniel1908 — Thu, 09 Sep 2021 07:47:32 GMT

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.

rbartley — Thu, 09 Sep 2021 08:24:23 GMT

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".

Daniel1908 — Thu, 09 Sep 2021 08:35:23 GMT

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])

rbartley — Thu, 09 Sep 2021 08:56:43 GMT

Please post your data in an Excel spreadsheet or other (removing anything confidential) so that I can look into it.

MayilVahanan — Thu, 09 Sep 2021 09:07:49 GMT

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'))

salonicdk28 — Thu, 09 Sep 2021 13:51:24 GMT

Or you can try this-

sum(aggr(If(Count([Text1])>1 or Count([Text2])>1,'Match'),[Text1],[Text2] ))

sunny_talwar — Thu, 09 Sep 2021 15:24:04 GMT

Are you trying to do this?

Aggr(If(Count([Text1]) > 1, 'Match Text1'), [Text1]) & ' and ' & Aggr(If(Count([Text2]) > 1, 'Match Text2'), [Text2])

Daniel1908 — Mon, 13 Sep 2021 06:17:04 GMT

This worked fine, thanks.

aggr(If(Count([Text1])>1 or Count([Text2])>1,'Match'),[Text1],[Text2] ))