Need to make this formula for totals

[Former Member]

this is really what I want to do for totaling. Can't work out the syntax.

IF {AEMPPF02.IDPRT#} <> 'FRTCMB' and {AEMPPF02.IDPRT#} <> 'FRTCME' then dd = dd + {AEMPPF02.EXTSHP}

[former_member203168 · Accepted solution]

Numbervar dd;

if not({AEMPPF02.IDPRT#}) in [ "FRTCMB", "FRTCME"]

then

dd:=dd+{AEMPPF02.EXTSHP};

OR

IF (({AEMPPF02.IDPRT#} <> "FRTCMB")

OR ({AEMPPF02.IDPRT#} <> "FRTCME"))

then

dd:= dd + {AEMPPF02.EXTSHP}

--Praveen G

[Former Member · Accepted solution]

thanks, just one thing can I add this AND to it?

Numbervar dd;

IF (({AEMPPF02.IDPRT#} <> "FRTCMB")

OR ({AEMPPF02.IDPRT#} <> "FRTCME"))

AND {AEMPPF02.IDPRT#} like 'FRT*'

then

dd:= dd + {AEMPPF02.EXTSHP}

[former_member203168 · Accepted solution]

You can Add AND in IFcondition.

[Former Member · Accepted solution]

You have the parenthesis right.  ((condition 1) OR (condition 2)) AND (condition 3)

I’m not sure “like ‘FRT*’” will work the way you want.
Try using STARTSWITH("FRT")

[Former Member]

whileprintingrecords;
global numbervar dd;

IF ({AEMPPF02.IDPRT#} = 'FRTCMB')
OR ({AEMPPF02.IDPRT#} = 'FRTCME')
then dd:= dd

else dd:= dd + {AEMPPF02.EXTSHP}