If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|