```This is giving me invalid expression - what hav...
# suiteflow
m
Copy code
This is giving me invalid expression - what have I missed? I started getting the error when adding the OR (||) bit...

({total} + {entity.consoloverduebalance} > {entity.creditlimit}) || ({total} + {entity.overduebalance} > {entity.creditlimit})
r
Have you tried putting everything inside a parenthesis
j
I'm not sure where you're entering the expression, but in oracle SQL || is the concatenate operator. I only suggest this because the formula looks fine to me as is
m
Yup looks like you want to change the
||
to
OR
m
Thanks. OR no longer throws invalid expression error. The expression evaluates to false when it shouldn't. ({total} + {entity.consoloverduebalance} > {entity.creditlimit}) OR ({total} + {entity.overduebalance} > {entity.creditlimit}) Also tried by removing the brackets before both total fields. Something isn't right in the expression
j
is this the whole expression, or are there other terms in there too?
m
That's the whole expression
j
can you put each of the fields in their own columns (total, entity.consoloverduebalance, entity.creditlimit, entity.overduebalance) and check the data makes sense? Could it be fields being set to NULL?
m
I think it's working now - when testing I didn't have a parent set on the customer and my fields were referencing the consolidated fields which requires a parent. And yes, it's OR not ||. Thanks, all.