Skip to Content
Former Member
Oct 03, 2016 at 09:43 AM

Critical issue with categories done with "if then else"


Hello all,

I have a critical issue managing categories with thousands of data.

The aim is do group data thanks to several parameters coming from different columns.

The grouping is done in several ways and priorities:

The first group is done thanks to a column A (ex: if(Length({Trucks}>0 then "Truck")

The second group is done thanks to a column B (ex: if(Length({Planes}>0 then "Plane")

The 10 other groups are done thanks to different values from columns C and D (ex: if(Contain({Vehicle},"Turbo") then "Sport car" else if (Contain({Vehicle},"2 wheels") then "Motorcycle" else if({Price}>50 000) then "Luxurious Vehicle" ...

It is crucial to respect the order.


Lumira only takes into account the first group and don't take into account the other ones.

This is not a coding issue, because the third case works very well with the very same structure (if x1 then y1 else if x2 then y2 else if...).

It might be due to a memory overload.

Do you have any solution for this issue?

Many thanks in advance,