Formula in Pivot Table

  • Thread starter Thread starter wiwi
  • Start date Start date
W

wiwi

I have problem with Pivot Table formula. I created a pivot table -
external data source. The pivot table is working fine, only problem
with formula.

E.g I have these fields :
PostMonth Text 6 example
:200511
JanQTY Numeric 15
DecQTY Numeric 15

I created a calculated fields formula in the pivot table:
PMONTH =Value(RIGHT(PostMonth,2))
JQTY =1

JanQty= IF(JQty>PMONTH,0,JanQTY) --- this formula is not working.
but if I put the PMONTH = 11, then can work.
 
If PostMonth is a text field, its value is zero, and Right(0,2)=0

Perhaps you can do the calculations in the external data source, and add
those calculated fields to the pivot table.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table report invalid 0
making an excel table visible for external data on pivot table 1
Menu Item Options -> Formulas Disabled for Pivot tables. 2
Pivot Table Solve Order 1
Adding a Formula as a data variable in a pivot 5
calculated column in pivot table 1
pivot table loosing decimals (vba) 1
Possible to use pivot table on non-mumeric fact data withoutcalculating? 3

Back
Top