Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Annualizing a yield - Bar Chart Expression

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!

0 Replies