Reg-negative value in target

Fri, 22 May 2015 03:15:46 GMT

Hi team

we have created the straight table with the dim as TA NAME,BRAND,PACKAGE.

we have written expressions like

Actual=sum(actual)

target=sum(target)

N-1 actual=sum(n-1 actual)

YTD ACTUAL=Sum(ytd actual)

YTD TARGET=sum(YTD target)

but we are getting negative value in target..if select brand-=essen and Bu=cvim and year=201504. i want the positive value in target.

Below is the script.can any one help me out from this.its very urgent.

SELECT Actual,

AreaName,

Brand,

BrandName,

CASE WHEN AreaName LIKE '%CVIM-Essentiale%'

THEN 'Essentiale Hospital' else BU end as BU,

Category,

"MAT Actual",

"MAT N-1 Actual",

"MAT Target",

"N-1 Actual",

Package,

Period,

PriceType,

ProvinceE,

RSMHC,

RSMHCID,

TAName,

Target,

"YTD Actual",

"YTD N-1 Actual",

"YTD Target"

FROM "Rx_BI_Qlikview".dbo."dataset_complete_report"

where Period >='201503'

Re: Reg-negative value in target

Gysbert_Wassenaar — Fri, 22 May 2015 05:29:16 GMT