Percentage calculation with null Dimension values.

Fri, 07 Jun 2013 20:52:59 GMT

how to get the total with out null values...

Column1 Column2

Sale 20

Share 10

Rev 40

- 10

I need to calculated the percentage not with the column1 having '-' .

%Column 3= Sum(Column2) / Sum(total Column2) which will be

Also I have selected "Supress when value is Null" option and it is providing me the below result

Column1 Column2 column3

Sale 20 20/100

Share 10 10/100

Rev 40 40/100

But i need to display the chart as below and how can i get it in expressions but not changing in the script.

Column1 Column2 column3

Sale 20 20/90

Share 10 10/90

Rev 40 40/90

Thanks

Re: Percentage calculation with null Dimension values.

CELAMBARASAN — Fri, 07 Jun 2013 21:16:17 GMT

Try with this

%Column 3= Sum(Column2) / Sum({<Column1={"=not IsNull(Column1)"}>} total Column2)

%Column 3= Sum(Column2) / Sum({<Column1={"*"}>} total Column2)

Hope it helps

Celambarasan