Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the expression to calculate the Units. But i am having some negative Units (Value) which i dont want to include in the calculation.
=num((Sum({<Type = {'AB','CL'},
[Year] = {$(=max([Year]))}, [Month] = {"<=$(=max({<[Year]={$(=max([Year]))}>} [Month]))"}>}[Units])),'##,##0')
How do i do this?
Any help please?
=num((Sum({<Type = {'AB','CL'}, Units -={},
[Year] = {$(=max([Year]))}, [Month] = {"<=$(=max({<[Year]={$(=max([Year]))}>} [Month]))"}>}[Units])),'##,##0')
Thanks,
Ahmed
Have you tried using it like the below:
=num((Sum({<Type = {'AB','CL'}, Units ={">0"},
[Year] = {$(=max([Year]))}, [Month] = {"<=$(=max({<[Year]={$(=max([Year]))}>} [Month]))"}>}[Units])),'##,##0')
Have you tried using it like the below:
=num((Sum({<Type = {'AB','CL'}, Units ={">0"},
[Year] = {$(=max([Year]))}, [Month] = {"<=$(=max({<[Year]={$(=max([Year]))}>} [Month]))"}>}[Units])),'##,##0')
=num((Sum({<Type = {'AB','CL'},
[Year] = {$(=max([Year]))}, [Month] = {"<=$(=max({<[Year]={$(=max([Year]))}>} [Month]))"}>} rangemax(0,[Units]) )),'##,##0')