Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I try to calculate CM1% (contribution margin in %). This shall be done for only 2019.
avg({$<$(vL.CY)>}((CM1)/([Net Sales Amount]))) is the one I have tried recently. That gives a little bit higher values than it should.
vL.CY variable is: [Booking ActualDate]={1},[Booking YearsAgo]={$(=min("Booking YearsAgo"))}
This expression works for calculating the right CM1% value (however this summarize for longer period, I only want current year.)
sum({$<[Booking ActualDate]={1}>}[CM1])/sum({$<[Booking ActualDate]={1}>}[Net Sales Amount])
Anyone see what causes the error?