Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one dimension and three expressions
Dimesnion - if(DATE>='12/31/1980',YEAR)
Expression1 - avg({<NAME={'A'}>VALUE))/100
Expression2 - avg({<NAME={'B'}>VALUE))/100
Expression3 - avg({<NAME={'C'}>VALUE))/100
Now i want to hide YEAR in my chart for any quarter Q1,Q2,Q3,Q4 is null for those NAMES in the expression, then whole YEAR Should not be shown in my Chart.
Please let me know if there are any concerns
Thanks
Avinash
wtz the output you are expecting for? some thing like this...
Sorry for wrong requirement to jagan and @sunny T and Pradeep.
Many thanks for your help.
Actually the values are not 'null' in my data base it is '0.0' values so that's why it is not working.
Now I have resolved the issue and it is hiding the YEAR's and Chart is displaying correctly.
Many thanks once again
Thanks
Avinash
HI,
If you got the answer close this thread by giving Correct Answer to the post which helps you.
Regards,
Jagan.
Hi All,
if(isnull(((avg({<NAME={'A'},QUARTER={'Q4'}>}VALUE))/100))
or ((avg({<NAME={'A'},QUARTER={'Q4'}>}VALUE))/100=0
or
isnull(((avg({<NAME={'A'},QUARTER={'Q3'}>}VALUE))/100
or ((avg({<NAME={'A'},QUARTER={'Q3'}>}VALUE))/100)=0
or
isnull(((avg({<NAME={'A'},QUARTER={'Q2'}>}VALUE))/100
or ((avg({<NAME={'A'},QUARTER={'Q2'}>}VALUE))/100=0
or
isnull(((avg({<NAME={'A'},QUARTER={'Q1'}>}VALUE))/100
or ((avg({<NAME={'A'},QUARTER={'Q1'}>}VALUE))/100=0
, null(),
((avg({<NAME={'A'}>}VALUE))/100)