Dependent dropdown list get filtered price

[JuanMata]

Hi

I've created a dependent dropdown menu but I'm finding it hard to get the price.

I've managed to get the price by following the exact same route as the previous dropdown lists but the price shows up as a select box, I need the price but I just want it to be on show.

How can I do this?

I've tried using 'App formula' and select the same field but I get this error 'The expression is valid but its result type 'List' is not one of the expected types: Price'

What am I doing wrong?

[JuanMata]

If I ignore the error and safe the app, I get this error 'Column Name 'Purchase Cost (Per Metre)' in Schema 'Quotes_Schema' of Column Type 'Price' has an invalid app formula '=Media[Purchase Cost (Per Metre)]'. The type of the app formula 'List of Price' does not match the column type 'Price'.'

[Steve]

Use Valid If rather than App formula.