Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

IF OR function for calculation to remove error that returns

Hi everyone,   I'm attempting to write an if or formula that will calculate the percentage of payment of revenue. Essentially a collection rate. For all that have numbers greater than 0 in both rev...
Need Help
hnguy71's avatar
hnguy71
Super User
4 years ago

Anonymous ,

Try this instead, assuming this is a calculated column:

DIVIDE([Insurance Payment Grouping.Insurance Payment], [Insurance Revenue], 0)