Struggling with calculated fields....

[spjmorris]

Hi all

not been on here for a while and hoping someone can help as I'm struggling to get to grips with calculated fields

I have a pivot that gives me a count of a reason name. The reason names are text values in the table (DOA, Wrong Product etc)
I'm trying to multiply a count of the reason name by a fixed value, is it possible?

The fixed value is 67 - I tried =COUNT('Reason Name')*67 but this just gives me 67 regardless of the actual count in the pivot row

sounds simple enough but I just can't get it to work...what am I doing wrong?

Thank you
Steve

 

[eibi]

If you are trying to count and multiply in the same cell, you can use a formula such as this:

=COUNTIF(B2:B10,"Reason Name")*67

If your count is a field in a pivot table, you will want to use a formula something like this:

=GETPIVOTDATA(.....)*67

 

[Chihiro]

Another method is to add helper column in source data range.

Just fill the column with 1. Then in calculated field use following:
= Helper*67

Edit: Never mind about the second method (using 2 calculated fields). It won't work on second thought.