Hi, whenever I try to reference a set of results I have in a “YIELD” column I get an error. the yield data is the result of a nested IF formula which itself references a single select field. Is there something I’m missing that means this data can’t be referenced by another formula?

The Yield formula is:

IF(TYPE = “Firkin”, “62”,

IF(TYPE = “Pin”, “31”,

IF(TYPE = “20L Keg”,“0”,

IF(TYPE = “30L Keg”,“0”,

IF(TYPE = “24 Case”,“24”,

IF(TYPE = “20 Case”,“20”,

IF(TYPE = “18 Case”,“18”,

IF(TYPE = “12 Case”,“12”,

IF(TYPE = “8 Case”,“8”,

IF(TYPE = “6 Case”,“6”,

“”))))))))))

Where TYPE is a single select field. But even if I try another formula field with YIELD*2 I get an error.

Any help much appreciated!