Hello everyone
I have a list, country, city..count(orders) and I would like to add a column % - count(order)/total(count(order)) but the result for every row is 100%. Can you please advise? Also the insert calculation button is inactive for count(order) column. Thank you for your help.
R.
Quote from: orbair on 18 Jun 2014 03:26:59 AM
Hello everyone
I have a list, country, city..count(orders) and I would like to add a column % - count(order)/total(count(order)) but the result for every row is 100%. Can you please advise? Also the insert calculation button is inactive for count(order) column. Thank you for your help.
R.
How about count([Order item] for [Country],[City]) / count([Order item] for report)
Cheers!
MF.
Thanks MFGF, it works :)