Hi all,
I have been trying to implement the SUMCT function over the absolute values of forecaste sales quantity.I have the requirement to obtain the total of absolute value.
Forecaste AbsForecaste SUMCT(Abs Forecaste)
20 20 100
-10 10 100
40 40 100
-30 30 100
above should be the output for SUMCT where as I am getting SUMCT column as 20..As it is not calculating on absolute but actual values.Is there anyway to implement this logic.
Helping approaches will be rewarded
create another Formula Column instead of using ABS operator use the folloiwng formula.
(Forecast < 0) * (Forecast * (-1)) + (Forecast >=0)* (Forecast)
Then create SUMCT on this Formula.
Add a comment