SUMCT of ABSOLUTE values

[P095090]

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

[former_member189638]

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.

[P095090]

Hi Rakesh..

I have tried this too..still it is calculating takin inot consideration the real values and not the +ve counterpart.

[Former Member]

Hello,

create a CKF1 on forecast and not formula keyfigure to calculate absolute value. Then create one more CKF2 over CKF1 with exception aggregation as total and reference object bein the one with lowest granularity in the report. then create formula KF for SUMCT CKF2.

Eg If your report is like below

Char1 Char2 Char3 Char4 Forecast CKF1 CKF2 FormulaKF

Create CKF1 with formula abs forecast

Create CKF2 with CKF1 and exception aggregation as total and refernce char as Char4 (as it is the lowest granularity)

Create FormulaKF with formula SUMCT CKF2.

This will def work.

Regds,

Shashank

[P095090]

Sorry Shashank..

But this is not helping me out