Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Calculation Rate by Year

Trying to get the Rate based on the following:   2021 SBNA RATE = IF('sz858m vwSBNAFinalATTPCnts'[Sale_Year] = 2021, 'sz858m vwSBNAFinalATTPCnts'[SBNA Volume]/SUM('sz858m vwSBNAFinalATTPCnts'[Sale...