RESOLVED - Ratios in list

[bpothier]

Hi,

I have a list applet with a column of activity type. I have this filtered to only return certain values. What I am looking to do it divide 2 of the returning values into each other to get a ratio of 1 to the other

field is activity type
filter returns values of call placed and sale made
would like a column that shows sale made/call placed to get a ratio

Is this possible?

[bi4u2]

One way to do this would be to create 2 new data items in your query that will not be displayed on the list report 'No of calles made' and 'No sales made'. You could create a conditional formula to put a '1' in as a value and then sum that value up and use it in a calcution for a 3rd field called 'Ratio of calls to sales'.

[bpothier]

that worked - thank you