Select in Field - Search String - If conditon

dhanavindhan — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I need to filter my record by using the Select in Filed - Search String.

I created a button then set this following for my button action.

It is fully based on my Filter (SRRChargeID)

Select in field

Field: "SRRusdamt"

Search String: 0

This is working fine.

The issue i am facing now is,

Some "SRRChargeID" not having 0 in "SRRusdamt".

So while selecting that type of ChargeID as my filter it's showing me other SRRchargeID's which has 0 value.

I don't want them. It should work only for my filter based condition. If there is no 0 mean it should be blank. How to resolve this issue?

What type of "If" condition i need to write in the search string value so i can get blank if there is no 0 amt for my serach based condition.

Pls help me.

Regards,

Dhana R

Re: Select in Field - Search String - If conditon

tamilarasu — Tue, 27 Mar 2018 09:11:13 GMT

Try this,

=If(Count({<SRRReport.usdamt={'0'}>}SRRReport.usdamt)>0,0)