<div>
Probably replacing 'and' with 'or' will solve your problem, but I do not know what exactly you wnat to do!
</div>


Probably replacing 'and' with 'or' will solve your problem, but I do not know what exactly you wnat to do!

<div>
Forced accept.<br />
<br />
Computer101<br />
EE Admin
</div>


<div>
<div class="content wysiwyg-content">
Hi experts <br />
Can anyone help with this formula <br />
For some reason the {P.ARC} = 'N' is not working for one of the sets of records and it is bringing back values where the P.ARC is not 'N' <br />
<br />
Thanks for your help<br />
RD<br />
<br />
<br />
if IsNull({P.AMT}) then<br />
(<br />
&nbsp; 0<br />
)<br />
else<br />
(<br />
&nbsp; if ( {P.REF} in [3678,1657] and {P.ARC} = 'N' ) then<br />
&nbsp; (<br />
&nbsp; &nbsp; &nbsp;{P.AMT}<br />
&nbsp; )<br />
&nbsp; else<br />
&nbsp; (<br />
&nbsp; &nbsp; &nbsp;if {P.ARC} = 'C' then<br />
&nbsp; &nbsp; &nbsp; &nbsp; {P.AMT}<br />
&nbsp; &nbsp; &nbsp;else<br />
&nbsp; &nbsp; &nbsp; &nbsp; 0<br />
&nbsp; )<br />
&nbsp; )
</div>
</div>


Hi experts 
Can anyone help with this formula 
For some reason the {P.ARC} = 'N' is not working for one of the sets of records and it is bringing back values where the P.ARC is not 'N' 

Thanks for your help
RD


if IsNull({P.AMT}) then
(
  0
)
else
(
  if ( {P.REF} in [3678,1657] and {P.ARC} = 'N' ) then
  (
     {P.AMT}
  )
  else
  (
     if {P.ARC} = 'C' then
        {P.AMT}
     else
        0
  )
  )

Formula bringing back duplicates

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.