custom field with custom formula in pivot table!

[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

 

[Debra Dalgleish]

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.

 

[Sedaghat Nejad]

Thanks a lot for your attention

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