Formula in Pivot Table

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.
 
D

Debra Dalgleish

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.
 
Top