Sum if field not starts with cm

[#1]

Hi,

I want to sum the field 'price' if the field 'type' does not start with cm.

And I also want to sum a other field if the orderDate is between the chosen date and 10 weeks before the chosen date.

I tried to modify this =SUM({$<Year={$(=Only(Year)-1)}>} Sales) to make it work but I can't get it to work.

Kind regards,

[jagan]

Hi,

Then try this way

=Sum(If( Factuurnummer LIKE 'CN*' OR IsNull(Factuurnummer) OR Len(Factuurnummer) = 0,

     Sum({<Factuurnummer-={"CN*"}>} Invoerbedrag)))

Hope this helps you.

Regards,

Jagan.

[#3]

Doesn't work either.