Hi All,
I'm having trouble thinking of a way to create a formula to work out ratio of cost.
The table below shows what I want to see.
My query pulls out the Cust ID, number of days, and USD value (it shows how quickly customers are paying their bills).
The Ratio I've manually added and needs to be calculated against 0 days (IE 60 days USD divided by 0 days USD).
The problem im having is how to make the ratio formula (as there are multiple customers – in below yellow ratio should be calculated on cust ID 111 and blue should be the same formula but calculated on cust ID 222).
Thanks for any advice.
(Edit update - format issue - looking to re attach table)
I'm having trouble thinking of a way to create a formula to work out ratio of cost.
The table below shows what I want to see.
My query pulls out the Cust ID, number of days, and USD value (it shows how quickly customers are paying their bills).
The Ratio I've manually added and needs to be calculated against 0 days (IE 60 days USD divided by 0 days USD).
The problem im having is how to make the ratio formula (as there are multiple customers – in below yellow ratio should be calculated on cust ID 111 and blue should be the same formula but calculated on cust ID 222).
Thanks for any advice.
(Edit update - format issue - looking to re attach table)
Attachments
Last edited:
