Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i have the below expression
Sum(TOTAL <[Product Group], [Part Type], Contract_Type_Group,District,[System Code]> Consumption)
In the above expression i need to add where it is sum of Consumption should be replaced by
(sum(Consumption)*12 / Count(Distinct Year & Month))
Can you please help how to do it.
Thanks,
Bharat
Don't really understand it. Sample? 🙂
I won't be able to offer much help without a sample file where you can show me what you are getting and what you intend to get