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
Steven VermoereAsked:
Who is Participating?
 
Rob HensonConnect With a Mentor Finance AnalystCommented:
Mathematically, your formula DAYS / COUNT(Audit) will give the same result as TEMPS.

DAYS = COUNT(Audit) * TEMPS

Therefore

DAYS / COUNT(Audit) = TEMPS

What are you aiming to achieve, I guess it isn't just another row with the same data?

Thanks
Rob H
0
 
Rgonzo1971Commented:
Hi,

Could you send a sample?

Regards
0
 
Steven VermoereAuthor Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.