I need to create three columns of data from two columns in a table.

Very simple, but something is failing.

One column is the item_ref, so contains a load of text values. Other is the currency values, base_price. Three columns I need are SOR, MATS, HOURS.

SOR is all values in base_price except where MATS / HOURS are involved, so formula is

if {Ccs_Q_Sections.Ccs_Qos_Item_Ref} <> ["MATS", "HOURS"]
/then {Ccs_Q_Sections.Ccs_Qos_Base_Price#6}

fine.

others are similar to each other of course:

if {Ccs_Q_Sections.Ccs_Qos_Item_Ref} = "MATS"
then {Ccs_Q_Sections.Ccs_Qos_Base_Price#6}

if {Ccs_Q_Sections.Ccs_Qos_Item_Ref} = "HOURS"
then {Ccs_Q_Sections.Ccs_Qos_Base_Price#6}

These just show zero, where I can see item_ref is shown and MATS, HOURS come up in the same row. Should see the value. These formulae are wrong.

I have a feeling you'll be able to spot immediately what I am doing wrong!

Thanks