Folks
I am a newbie and sincerely appreciate your expert input.
I have a calculated expression that divides Sum of Income/Sum of Sales ... however What I need to do is have this yield calculation annualized by dividing it by the number of calendar days in the month x 365.
Therefore, the January yield should be Sum of Sales/Sum of Balance/31*365
Similarly, each data point in the graph for the corresponding month should be annualized based on the number of days in the month.
How can I write this expression? I am creating a calendar as an object to specify the date range as well.
Thank you so much!