Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Month | Amount | Paid | Ratio |
---|---|---|---|
Jan | 10 | 100 | 0.1 |
Feb | 0 | 100 | 0.1 |
Mar | 100 | 200 | 0.6 |
Month | Amount | Paid | Ratio |
---|---|---|---|
Jan | 10 | 100 | 0.1 |
Feb | 0 | 100 | 0.05 |
Mar | 100 | 200 | 0.275 |
See attached example.
In case you only have personal edition:
Dimension: Month
Expression 1: sum(Amount)
Expression 2: sum(Paid)
Expression 3: RangeSum(above(Amount, 0, FieldValueCount('Month')))/RangeSum(above(Paid, 0, FieldValueCount('Month')))