I want to round or ceiling to the nearest .25 with this app formula.
IF( iSBLANK([amount]) ,CEILING([calc hours]) * LOOKUP([Equipment], โServicesโ, โServiceโ, โRateโ) , LOOKUP([Job Name], โAccountsโ, โAccountโ, โAmountโ))
Some rates are $250/hour so I need to round by decimal places rather than by integers.
Solved! Go to Solution.
@CMsDeveloper You can do that like CEILING([YourDecimalValue]*4)*0.25
Thereโs no built-in function to do what you want, so youโll have to calculate it.
@CMsDeveloper You can do that like CEILING([YourDecimalValue]*4)*0.25
Thats a lot cleaner of an expression that I had envisioned; cheers Aleksi.
Perfect. Thanks!
@Jonathon Simple is more beatiful
Youโre welcome
User | Count |
---|---|
43 | |
29 | |
29 | |
14 | |
14 |