I'm trying to create a table that has the time left on a customer's contract in the final field.
Currently the columns are customer ID, customer name, and customer contract numbers.
I added a calculated field that used the function DATEDIFF('day',[END_DATE],date(today()),'sunday').
This returned a number (how many days left on contract) but was adding a small graph to the end of my worksheet, instead of just an integer next to the contract number.
I then added another calculated field dividing my original calculation by 365, so that I could have the years.
Again, this worked but is giving me a graph in that column. I just want the integer, which I can see when I hover over the graph, not a graph within my sheet.
Have you tried this?
Let me know If you've any query