• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 341
  • Last Modified:

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
0
Steven Vermoere
Asked:
Steven Vermoere
1 Solution
 
Rgonzo1971Commented:
Hi,

Could you send a sample?

Regards
0
 
Rob HensonIT & Database AssistantCommented:
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
 
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

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now