Bux32
1
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?
Jopp
2
Replace cost !=""
with cost !=null
holroy
3
How is your cost
property written? Could you show examples from source mode and/or live preview?
Bux32
5
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
Bux32
7
Oh thanks, I didn’t know that, I will look into it and let you know if it works