Replacement of If statement

[aatish12345]

Hello everyone,

I am using a calculation in dimension with if clause as shown below

=If(A<B, A)

And this dimension I am using in table., 

Here if I am selecting data in A field, automatically data in B field is getting selected and i don't want it . hence I want an alternative to this statement so that I can avoid the selection in field B after selecting data from field A.

Kindly help!

Aatish

[stevejoyce · Accepted solution]

You can try this, and uncheck "Include null values"

=aggr(only({<a={"=a<b"}>} a),a)

[aatish12345]

Dear Steve,

Your solution is perfectly working as expected.

Thanks for the help!

Aatish

[aatish12345]

Dear Steve, In the solution that you have provided, I want to bypass Region field in order to avoid selection of region field on the table data. for that I have just added region field as shown below

=aggr(  {<[Region]=>}  only({<a={"=a<b"},[Region]=>} a),a)...but the region field selection is still happening on the data

Can you plz help with any possible solution

Aatish