23 Replies Latest reply: May 28, 2014 12:54 AM by Nishika Tamta

# How to calculate % in the table of chart properties.

I am trying to calculate the percentage ,i am not able to sum the values of the Grand total because it is the expression in the chart option.The expression for grand total is: count({<CategoryDefect={'Application','User Training','Environment','App Config','Scope Change','Duplicate'}>}CategoryDefect).The Grand Total value is not static value it will change according to the selection of product line.

I have uploaded the excel sheet of the table that i want to be displayed  .

Thanks.

• ###### Re: How to calculate % in the table of chart properties.

Hey,

To get the percentage as another column,do use (Grant Total/Sum(TOTAL Grant Total))*100

but, to get at the bottom of the chart, I think u need to make use of text boxes.

HTH,

Ravi N.

• ###### Re: How to calculate % in the table of chart properties.

i tried to take (Grant Total/Sum(TOTAL Grant Total))*100  it is showing Blank.No values are coming.

• ###### Re: How to calculate % in the table of chart properties.

It should work. It worked for me. Nonetheless,use relative option. Just use sum(Grand) as exp and click on relative in the expression tab.

• ###### Re: How to calculate % in the table of chart properties.

(sum(Grant Total)/Sum(TOTAL Grant Total)))*100

• ###### Re: How to calculate % in the table of chart properties.

Hi May be like this

(sum(Grant Total)/Sum(TOTAL Grant Total)))*100

Or use Relative on expression.

Regards

ASHFAQ

• ###### Re: How to calculate % in the table of chart properties.

Hi Nishika,

I tried your problem and i found the following solution that i tried in text box. it is as follows

=Num(Sum(TOTAL Application)

/

(Sum(TOTAL Application)+ Sum(TOTAL User Training)+ Sum(TOTAL Environment)+Sum(TOTAL APP Config)+Sum(TOTAL Scope change)+Sum(TOTAL Duplicate)),'#.#%')

you will get the 46.94% for ''2521/5370"

check it out.

• ###### Re: How to calculate % in the table of chart properties.

Hi nishika,

please find attached QVW with solution

regards

harshal sonone

• ###### Re: How to calculate % in the table of chart properties.

Hi Harshal,

I am not able to do it it is showing error in the statement ,I have attached the qvw file please check .

• ###### Re: Re: How to calculate % in the table of chart properties.

Hi,

may be like this.

Regards

ASHFAQ

• ###### Re: Re: How to calculate % in the table of chart properties.

Hi Ashfaq,

Thanks for your it is working now but how to add this percentage at the bottom also.

Application,User Training,etc etc ...

ex.  7/27 %        ,4/27

• ###### Re: Re: Re: How to calculate % in the table of chart properties.

Hi,

May be like this.

Regards

ASHFAQ

• ###### Re: Re: Re: How to calculate % in the table of chart properties.

Hi,

I need  row at the bottom for % .Please find the attached screen shot.

• ###### Re: Re: Re: Re: How to calculate % in the table of chart properties.

Hi,

One of the work around could be like this.

Regards

ASHFAQ

• ###### Re: How to calculate % in the table of chart properties.

hi,

this is how you can do it. if u want i can attach QVw.

regards

harshal sonone

• ###### Re: How to calculate % in the table of chart properties.

Hi,

Please attach the Qvw file and can i add  separate row for percentage at the bottom in the table option of the chart properties .You are showing it as a row i just want is the total % only to be shown at the row of each product line.For eg.15% should come at the bottom of 4.

App Config,   Application etc etc ...

Total     4               ,  7

%     15%          ,  26%

• ###### Re: How to calculate % in the table of chart properties.

Hi,

did you look at my solution status1.3.qvw

Regards

ASHFAQ

• ###### Re: How to calculate % in the table of chart properties.

yes i do in status 1.3 but in that you are calculating each row but i want is

7/27  (27 is the grand total sum) then for App Config  4/27  same for all the columns .

A separate row should be added at the bottom

• ###### Re: Re: How to calculate % in the table of chart properties.

Hi,

I did the same.

I prefer you to go through 1.3 once.

Look at the image attached.

The one you posted is for 1.2

Regards

ASHFAQ

• ###### Re: How to calculate % in the table of chart properties.

hi Ashfaq,

Thank you soo much i got it .

• ###### Re: Re: How to calculate % in the table of chart properties.

HI nishika

PFA qvw.

• ###### Re: How to calculate % in the table of chart properties.

Hi Harshal,

Thank soo much .

• ###### Re: How to calculate % in the table of chart properties.

Hi

In chart properties for Number Tab against the expression set the number format to 2 decimal and check show in Percent option

Thanks

Satish

• ###### Re: How to calculate % in the table of chart properties.

Hi Nishika,

Just go to the Chart's properties.

Select the Grand Total expression in expression tab,then check the "Relative"  check box for the GRAND Total expression.