How to create different rounding brackets per country - where the value is lower than the bracket limit (custom rounding up)
started a topic
about 1 month ago
I've got perhaps a somewhat unusual question.
I'm trying to roundup values to a specific set of values specified in a secondary file. I can do it by writing a calculation like
If [value field] <= 50, then 50
if [ value field] <= 100, then 100 etc.
However, in different countries, and across different years these brackets may be different. So I'd like a sustainable solution that relies on actual input data as to what brackets exist, instead of hard coding these in a calculation.
How would you solve this in omniscope?
As example I've added an example set of 5 records with a KG value that requires grosses up,
The specific weight brackets are the right of the example records.