Post

2 followers Follow
0
Avatar

Formula issues

I want to create a custom field that is a division formula.  First it needs to the the sum of the fields.  Second issue I have is the one field is currency and the other is duration.  How can I convert, I can not delete the filed for it has data in it.

Example:

Sales Amount = Currency

Budgeted Hours = Duration

In report I have it set to Totals "Sum"

I want to talk the sum of Sales Amount / sum of Duration

 

 

Brian Yeager

Please sign in to leave a comment.

1 comment

0
Avatar

Hi Brian,

In order to divide currency by duration, you will need to convert them to numeric values first. You will also need to make sure to avoid division by zero. For example: If(($BudgetedHours / Hours(1) > 0, ($C_SalesAmount / Currency(1)) / ($BudgetedHours / Hours(1)), 0)

As for the report, please try different summary types to see if any perform the calculation you need.

I hope this helps.

Roland

Roland Pumputis 0 votes
Comment actions Permalink