custom field with custom formula in pivot table!

  • Thread starter Thread starter Sedaghat Nejad
  • Start date Start date
S

Sedaghat Nejad

Hi to all;
I have a pivot table that contain "task-start-date" field I want to add a
costom field to my pivot table with this formula : =today()-"task-start-date"
but I recieve syntax error from calculated field option from pivot table
tools cosole.
I hope someone help me.tnx
 
You can't use the Today or Now functions in a pivot table formula. You
could enter a static date, such as DATE(2009,5,31) and subtract the
other date from that.

However, it would be best to enter your formula in the source data, and
calculate the date difference there. Then add that new field to the
pivot table.
 
Thanks a lot for your attention

Debra Dalgleish said:
You can't use the Today or Now functions in a pivot table formula. You
could enter a static date, such as DATE(2009,5,31) and subtract the
other date from that.

However, it would be best to enter your formula in the source data, and
calculate the date difference there. Then add that new field to the
pivot table.




--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com
Click to expand...
 
Back
Top