How to exclude values from all calculations

[#1]

Hi all. I have a table like this. I know that I don't need Напитки at all, but I can't exclude them from the database.

Can I make a vitiable in a load script that will automatically make smith like this: if salescript_group_name = "Напитки" then points = 0;

Thank you!

[rubenmarin]

Hi Evgeniy, you can do in load script changing the way you load your Points field:

LOAD last_first_name,

     Points,

     If(salescript_group_name = 'Напитки', 0, PointsField) as Points

....