Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have two expressions - 'material cost' and 'item cost' which are being used for pricing analysis.
I wish to create a table which shows both values, but create an extra column which summarises the two values by returning the
smaller value.
Material Cost | Item Cost | Min of Material & Item |
---|---|---|
5.50 | 4.99 | 4.99 |
2.50 | 2.00 | 2.00 |
How do I need to write this expression? Can I use MIN...?
Many thanks,
Paul
Hi
Try like this
=RangeMin(column(1),Column(2))
You have to use RangeMin here
RangeMin([Material Cost], [Item Cost])
Alternatively, if you would like to use the calculated field in many different places, in your load script have something like:
LOAD
MaterialCost,
ItemCost,
IF(MaterialCost < ItemCost, MaterialCost, ItemCost) AS LowerOrSameAsValue,
...