custom field with custom formula in pivot table!
 

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

custom field with custom formula in pivot table!
 

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 wrote:
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
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

custom field with custom formula in pivot table!
 

Thanks a lot for your attention

"Debra Dalgleish" wrote:

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 wrote:
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
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com