Adding distance in kliometers

Hello all,
I need to calculate distance in kilometers according to following distance categorization which is as under:

within 15km from City center => Lokal Customers
From 15 to 50 km from city center => Distant Customer
From 50 km but within Germany => Online shopping Customer
Not in Germany => Foreign Customer

details of the table are as in figure:

Hi!

If you have distance calculated then use Rule Engine node :wink:

Br,
Ivan

1 Like

Hi,
Thank you for your reply. I will try and see.
Regards,
Q

Hi,
Kindly guide me how to use it it will be easier for me. I will be great ful to you.

Hi!

So in Rule Engine node you write rules similar to ones you already written. Here is Node description to check:

For example:
distance < 15 => Local Customer
distance < 50 => Distant Customer
country = Germany => Online shopping Customer
TRUE => Foreign Customer

This will work because β€œThe first matching rule in order of definition determines the outcome.”

Br,
Ivan

1 Like

Thank you