Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hey all
I am claculation a percentage in a line chart but i have a problem
when calculating the percentage i realize that there is some result has an answer greater then 100% at i don't want to show on the chart i need to show only that has a percentage less then 100 %.
Help Anyone ??
Thank you.
Put an if statement around your expression: =if( ...expression... >=1, 0, ...expression... )
Put an if statement around your expression: =if( ...expression... >=1, 0, ...expression... )
Hi,
you can build an IF_clause into your formula to calculate it only if the result is less than 100%.
There is also, on the "formula" tab of the dialog, an edit_field for a "condition", but i don't think that will work in your case. Or you can set a background_colour (when you click on the little PLUS_sign next to your formula) that, in case a percentage goes over 100%, matches your charting_area_colour so that it becomes invisible.
HTH