Hi,
I'm having an issue with a query field. I have a startDate & EndDate. I'm able to find out the number of years on a multiple contract, but I'm not able to find the yearly cost:
10/14/2020 - 10/14/2023 = 3
The cost for the 3 years is $60,000
I can't seems to find the correct formula for the yearly cost
my field for the 3 years is named Contract Duration/contract cost = $10,000, but the formula is not working. I setup the Contract duration field format as general number. What Am I doing wrong? Thanks in advance.