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?
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'.
that worked - thank you