I have created two calculated fields: one is currentyear MTD and the other one is previousyear MTD
I try to create third calculated field to have difference between two MTD. However, it won't work and value is blank
Could you please advise and what I am doing wrong?
I would have to see the calculations, but if the two fields are date/datetimes then use the datediff function in your calculated field. I hope this helps!