Forum Discussion

Copper Contributor

Jan 26, 2023

Solved

Calculation field in pivot table not working

so, i know this should be really simple, but it is not working for me!! i am beyond frustrated, when i looked at some of the issues on here, i feel really dumb, so i'm really hoping for something qui...

excel

Formulas and Functions

Riny_van_Eekelen
Jan 27, 2023
amylou1 Doesn't allow me to download. try sending it to me via a direct message.

amylou1

Copper Contributor

Jan 27, 2023

Riny_van_Eekelen I have checked to ensure that the date fields were formatted correctly and they were, I also changed to sum. I'm still getting the same results...I'm not sure how to attach the file...so I will do screen shots if that helps you...

thank you!

Riny_van_Eekelen

Platinum Contributor

Jan 27, 2023

amylou1 Formatting a range as Date does not transform its content to dates if they are texts to begin with. what do you get when you use =ISNUMBER(cell) where "cell" points to a cell with an approval date?

If TRUE then it probably is a date. If FALSE, then it is not.

Can you otherwise share a link your file on Onedrive, Dropbox or similar?

amylou1
Copper Contributor
Jan 27, 2023
also, got a true
amylou1
Copper Contributor
Jan 27, 2023
https://fldot-my.sharepoint.com/:x:/g/personal/amy_causseaux_dot_state_fl_us1/EdXoFn9MujFBi9O5PskrfCEBsOB3KV4kmBXKDza4FwOhVw?e=kLCzBG

I don't think this will work as it usually blocks from sharing outside of the department
- Riny_van_Eekelen
  Platinum Contributor
  Jan 27, 2023
  amylou1 Doesn't allow me to download. try sending it to me via a direct message.