Nedd to get the diffrence between dates and to implement it to the formula in RG

Need help Database
1

I have database like:
Amount - number
Start date - date
Finish date - date

And in RG i Want to display: Amount; and Amount divided by the Difference of Start and Finish Date rounded to month.

How Can i do it?
When I text smth like "Current cell’s amount / Finish Date - Start date rounded to month - the Result is mess.

2

Hi there, @akosyaassyl… I don’t really understand what you are doing with the rounded to month part, but if you enable the new (experimental) parentheses feature, something like the following expression seems like it could be what you described.

formula

Hope this helps.

Best…
Mike

3

Woooow!!! Thank you very much!!! Parentheses feature is great!

1 Like