Hi guys,
first of all, i have to say sorry, because my expressions in query were not exactly same as i had posted and working expression.
i figured it out, why i was having this issue, the reason is
1.) i was using Dollar-sign Expansion with expression.
2.)If i need to use alt() or RangeMax() or sign() , i should not use Dollar-sign Expansion with expression, inside these(alt() or RangeMax() or sign()) functions.This may lead to undefined result, which was causing me to give hypen.
3.)If in single row, your expresion contains alt() or sign() function with dollar expansion, then all rows in that particular column can result as not valid, which will be shown in hypen symbol
My expression was
if(Sign($(=Count({$<batch={'23','34'}>}invitation_id))=-1,0,$(=Count({$<batch={'23','34'}>}invitation_id))
Alt($=(Sum(delivered)),0)
In my above expression i should remove ' $(= ' Dollar expansion symbol, then you get the result.
Thankyou all of you, to answering or giving hint for my query.
