Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello;
I am trying to get the average of month per contract.
This is the formula used:
num#((num#(round((num#(Interval([Contract End Date]-[Contract Start Date],'dd')/365)*12))))/Count (DISTINCT Contract))
Even using the num#, it never provided a number in the total of the expression.
What to do in this case?
Thanks
Kristel.
Unfortunately this did not provide any result.
Not sure why???
Thanks for the effort