Guys,
My original formula logically returns nothing (empty field) when there is no number to return. All good and normal here
PLUCK(SELECT(SELECT(data.priceCount[0].gastronomy, item.curr == params.currParam), item.price == FIRST_ITEM(SPLIT(params.priceParam, " "))), "count")), + " options)"
Now I want to use DEFAULT() to display “0 options” in such case, to avoid having awkward ( options) on display.
I tried all of them and none display “0” when my formula returns null or empty:
"("+DEFAULT( PLUCK(SELECT(SELECT(data.priceCount[0].gastronomy, item.curr == params.currParam), item.price == FIRST_ITEM(SPLIT(params.priceParam, " "))), "count")),"0") + " options)"
"("+DEFAULT( IS_NULLY(PLUCK(SELECT(SELECT(data.priceCount[0].gastronomy, item.curr == params.currParam), item.price == FIRST_ITEM(SPLIT(params.priceParam, " "))), "count")),"0") + " options)"
"("+DEFAULT( IS_EMPTY(PLUCK(SELECT(SELECT(data.priceCount[0].gastronomy, item.curr == params.currParam), item.price == FIRST_ITEM(SPLIT(params.priceParam, " "))), "count")),"0") + " options)"
"("+DEFAULT( IS_NULL(PLUCK(SELECT(SELECT(data.priceCount[0].gastronomy, item.curr == params.currParam), item.price == FIRST_ITEM(SPLIT(params.priceParam, " "))), "count")),"0") + " options)"
Is DEFAULT() the right formula for having 0 displayed by default when my formula returns nothing from the database? Thanks