i have a bar chart with this products and sum(Sales) as expression fine.
here my req is
in chart as per req i created calculation condition count(products)<=1 if they select more than 1 products then it is going to display error mess called 'select only one product'
fine this is also working
here:
product is having data like
products:
apple
banana
orange
sapota
jama
here i have no data for jama and orange when i select orange or jama chart shows blank (because no data for these 2)
here i want display error mess when i select orange or jama it should give like 'no data for this '
how to do this ?
possible how to do this in dynamically
because i have 100 names in products ,if there is no data for 20 products how can i give dynamically.
finally saying when data is there it will display chart , when we select more than one it gives error mess like select only one
when data is not there it should display error mess is 'data is not avliable'?
No data means that none of the three expressions return a value other than zero. So you need to include an if clause that includes all the expressions: if(expr1 <> 0 and expr2 <>0 and expr3<>0, ....
