Hi - I have a dataset with multiple records for each date,currency (i.e more than one loan per statemenet date in each currency) .Each date has multiple currencies.Each currency has a FX rate.I am trying to work out the average FX rate over a time period on this dataset for a currency.I have got the function down to subset_uniquelist but omniscope can not take the sum or average of this as it is text.I am not be able to convert this to a value string which can be passed to the avg or sum functions.

The reason i need unique list rather than the entire subset is because there are multiple loans per date per currency and the number of loans per currency at each date varies depending on whether they pay their loans or not.For instance GBPEUR 1.22 say 30/09/2012 and GBPEUR 1.19 on the 31/08/2012 now i could have 80 loans on 30/09/2012 and 20 on the 31/08/2012 which would get one answer or i could haev 20 loans on the 30/09/2012 and 80 on the 31/08/2012 taking the average of these would produce differenct (and incorrect answers).I would just like the simple arithermtric average of (1.19+1.22)/2

Have you got any ideas how Omniscope can do this ? Thanks Ben