Hi All
I have two field in a product Min value and Max value.
I have the formula:
average($minimum_range_c,$maximum_range_c)
The Min amount is 376 and the max is 431 which works out as 403.5 but I need it to be 404 after rounding up.
I want to average these two values then round up. Is anyone able to help with this? Thanks again in advance.
Many thanks