Finding the min of two values

[#1]

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

[MayilVahanan]

Hi

Try like this

=RangeMin(column(1),Column(2))

[CELAMBARASAN]

You have to use RangeMin here

RangeMin([Material Cost], [Item Cost])

[kangaroomac]

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,

     ...