Formulas more/few allowed

[codrutza]

CRXI SQLServer2005

I have these formulas:

Detail:
@mov
(
if {SPExc;1.FMVia}="Sea" then
(
if {SPExc;1.FJMMType} in ["Delivery","Collection"] then 1
else if {SPExc;1.FJMMType} in ["Import","Export"] then 10
)

GroupHeader
@movgrheader
(
if {SPExc;1.FJVia}="Sea" then
(
if Sum ({@MovTypeSort Sea},{SPExc;1.FJJNo})>=20 then "Delete"
else ""
)
)

That is the way I built it and works, for more imports/exports than one, they must delete one mov. The rule is every job has a mov import/export. (And I’m suppressing the records with "").

It’s working very well, but now I have to add to the formulas a condition for a client who is allowed to have more imports/exports (if {SPExc;1.CCode}="ClientA").

Any suggestions I would appreciate.

 

[fisheromacse]

i am not sure i understand what you are asking, but maybe...

@movgrheader
(
if
(
{SPExc;1.FJVia}="Sea" and NOT({SPExc;1.CCode}="ClientA")
)
then
(
if Sum ({@MovTypeSort Sea},{SPExc;1.FJJNo})>=20 then "Delete"
else ""
)
)