back to notes

Total Margin Items

Total Margin for Power BI in Sales_opps_won

Total Margin = IF([ProdType]= "product" , [qty]*[margin], [Margin])

Total Margin for SSMS in Sales_opps_won

sum(CASE WHEN [ProdType] = 'Product' then ISNULL([Margin],0) * ISNULL([Qty],0) ELSE [Margin] END) as 'Total Margin'

I can explain more on it if need be


last updated december 2015