Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Quick question: I'm able to average simple variables, however, the avg. function doesn't seem to work when I'm using set analysis. In my business, we have several types of sales, all housed under the variable 'sales' and differentiated by another variable called 'transaction type'. I've been using set analysis to differentiate amongst the different types of sales and it works well. However, I'm unable to calculate averages, standard deviations, etc and I'm pretty sure it has to do with the set analysis.
Has anyone else found this problem? If so, is there a way around it? I've attached an example to help explain my issue better.
Thanks for the help!
Matt
Try this
avg({<[Transaction Type ID]={"10"}>} [Sales])
Works perfectly - Thanks Nick!