Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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))
Thanks for your help !
@marcus_sommer Many thanks !