You need to sign in to do that
Don't have an account?
Colleen Burnsed 8
Rounding numbers up to the next quarter increment
I have a summed value of 5.57, i want this value to be 5.75 (the next rounded quarter). If I try ROUND(5.57+.124, 2) this returns 5.69 not 5.75. What am I missing?
Try something like this:
If my answer was of help to you, please consider marking it as the Best Answer so this question can be marked as Solved. If it is not working, please let us know so we can look for another solution.
((IF([Property_Billable__c].Branch_State_Fees_Taxes__c.X9015__c != 0,
[Property_Billable__c].Branch_State_Fees_Taxes__c.X9015__c,
[Property_Billable__c].Branch_State_Fees_Taxes__c.X971__c)) + [Property_Billable__c].Branch_State_Fees_Taxes__c.Other_Insurance_Coverage__c + [Property_Billable__c].Branch_State_Fees_Taxes__c.Corporate_Admin_Cost_Percentage__c + [Property_Billable__c].Branch_State_Fees_Taxes__c.Woker_Comp_Buffer__c)*100
((IF([Property_Billable__c].Branch_State_Fees_Taxes__c.X9015__c != 0,
[Property_Billable__c].Branch_State_Fees_Taxes__c.X9015__c,
[Property_Billable__c].Branch_State_Fees_Taxes__c.X971__c)) + [Property_Billable__c].Branch_State_Fees_Taxes__c.Other_Insurance_Coverage__c + [Property_Billable__c].Branch_State_Fees_Taxes__c.Corporate_Admin_Cost_Percentage__c + [Property_Billable__c].Branch_State_Fees_Taxes__c.Woker_Comp_Buffer__c)*100
Here is what i was playing around with in sandbox;
ROUND(
((IF([Property_Billable__c].Branch_State_Fees_Taxes__c.X9015__c != 0,
[Property_Billable__c].Branch_State_Fees_Taxes__c.X9015__c,
[Property_Billable__c].Branch_State_Fees_Taxes__c.X971__c)) + [Property_Billable__c].Branch_State_Fees_Taxes__c.Other_Insurance_Coverage__c + [Property_Billable__c].Branch_State_Fees_Taxes__c.Corporate_Admin_Cost_Percentage__c + [Property_Billable__c].Branch_State_Fees_Taxes__c.Woker_Comp_Buffer__c)*4,0)/4
If you notice i don't have the .124 in there but that above formula did not get the right results.
ROUND((((IF([Property_Billable__c].Branch_State_Fees_Taxes__c.X9015__c != 0,
[Property_Billable__c].Branch_State_Fees_Taxes__c.X9015__c,
[Property_Billable__c].Branch_State_Fees_Taxes__c.X971__c)) + [Property_Billable__c].Branch_State_Fees_Taxes__c.Other_Insurance_Coverage__c + [Property_Billable__c].Branch_State_Fees_Taxes__c.Corporate_Admin_Cost_Percentage__c + [Property_Billable__c].Branch_State_Fees_Taxes__c.Woker_Comp_Buffer__c)*100 + 0.124)*4, 0) / 4
Can also try:
CEILING(VALUE/0.25)*0.25