Dataview for filtering prices

Hi, I’m trying to create a personal cookbook with recipes and cost per portion of the recipe.

I’m trying to create a dataview table that can show me the recipe if the cost is less than 5.0 and the cost property is not empty.

This is what I tried but it doesn’t show any recipe. Any suggestons?

Replace cost !="" with cost !=null

How is your cost property written? Could you show examples from source mode and/or live preview?

Sure

Doesn’t work


Maybe it’s the whole query that is problematic?

is the issue you’re treating 5.0 as a string with “5.0” in the comparison instead of a number?

if the property is saved as a string or as a mix of numbers and strings, you can use the number() function

https://blacksmithgu.github.io/obsidian-dataview/reference/functions/#numberstring

Oh thanks, I didn’t know that, I will look into it and let you know if it works