Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this,
=If(Count({<SRRReport.usdamt={'0'}>}SRRReport.usdamt)>0,0)