I need help with a set analysis. I have a database in which a line represents a batch with a reception date, a type and a weight. For each batch, I'd like to calculate a ratio = a constant defined by type / Total weight received per month of Receipt Date by type, which would remain independent of the user's filters
I've tried something like this without success Sum({<Type={'A'}>}Constant A) / Sum( Aggr( Sum( {1<Type={'A'}>}Weight),ReceptionMonthName))
