Steven Vermoere

asked on

# Formula not working in pivot table

I want to create a pivottable with the following values :

Column:

Number of days. This field is called "TEMPS"

Rows:

Row 1:

count of the datacolumn "AUDIT". This was very simple; I put the field "AUDIT" in the values and change it to count numbers instead of sum in value field settings. This is simply a count of all the different values.

Row 2:

Here I'm using a formula. I want to calculate the value in TEMPS with the value of row 1: Number of Days * count of Audit. For that I created a simple formula: count(AUDIT)*TEMPS. I called this formula "DAYS". It calculates correctly.

Now I want to a a third row that divides Row 2/Row 1.

When I try now to add a formula: DAYS/count(AUDIT) it does not work.

I have even tried the simple formula count(AUDIT), wich I think should give the same result as Row 1, but gives me always the number 1

Are there any suggestions ?

Steven

Column:

Number of days. This field is called "TEMPS"

Rows:

Row 1:

count of the datacolumn "AUDIT". This was very simple; I put the field "AUDIT" in the values and change it to count numbers instead of sum in value field settings. This is simply a count of all the different values.

Row 2:

Here I'm using a formula. I want to calculate the value in TEMPS with the value of row 1: Number of Days * count of Audit. For that I created a simple formula: count(AUDIT)*TEMPS. I called this formula "DAYS". It calculates correctly.

Now I want to a a third row that divides Row 2/Row 1.

When I try now to add a formula: DAYS/count(AUDIT) it does not work.

I have even tried the simple formula count(AUDIT), wich I think should give the same result as Row 1, but gives me always the number 1

Are there any suggestions ?

Steven

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Yes Rob,

You are completely right. The people asking me to create the pivottable have found out the same solution after you told me that I was also asking something that is already available.

Sorry for the bother

Steven

You are completely right. The people asking me to create the pivottable have found out the same solution after you told me that I was also asking something that is already available.

Sorry for the bother

Steven

Could you send a sample?

Regards