Expr

[smilingjohn]

Hi All,

I have a field called SPEND which has two strings in it Finance and Sales Iam using below expression in the PIE chart which dont have any dimensions ..this will display me the percentage value .. Can someone please tell me how do i include the DImensions value for only FInance in this expression ? this expression should always display the value for Finance from SPEND field .....

num(

(

sum(aggr(

if(

round(

(

(Sum({<MCERFlag = {1},>}CurrQtyReceived * CurrCostLocal))

-

(Sum({<MCERFlag = {1}>}CurrQtyReceived * PriorCostLocal))

)

-

(

(Sum({<MCERFlag = {1}>}CurrQtyReceived * CurrCostInvoiced*(CurrCostLocal/CurrCostInvoiced)))

-

(Sum({<MCERFlag = {1}>}CurrQtyReceived * CurrCostInvoiced*(PriorCostLocal/PriorCostInvoiced)))

)

)

>0,

(Sum({<MCERFlag = {1}>}CurrQtyReceived * CurrCostLocal))

,0)

,Entity_Item_Curr_MonthID,SpendCol))

)

/

(Sum({<MCERFlag = {1}>}CurrQtyReceived * CurrCostLocal))

,'#,##0.00%')

)

)

Thanks in advance

[Kushal_Chawda]

num(

(

sum(aggr(

if(

round(

(

(Sum({<MCERFlag = {1},Spend={'Finance'}>}CurrQtyReceived * CurrCostLocal))

-

(Sum({<MCERFlag = {1},Spend={'Finance'}>}CurrQtyReceived * PriorCostLocal))

)

-

(

(Sum({<MCERFlag = {1},Spend={'Finance'}>}CurrQtyReceived * CurrCostInvoiced*(CurrCostLocal/CurrCostInvoiced)))

-

(Sum({<MCERFlag = {1},Spend={'Finance'}>}CurrQtyReceived * CurrCostInvoiced*(PriorCostLocal/PriorCostInvoiced)))

)

)

>0,

(Sum({<MCERFlag = {1},Spend={'Finance'}>}CurrQtyReceived * CurrCostLocal))

,0)

,Entity_Item_Curr_MonthID,SpendCol))

)

/

(Sum({<MCERFlag = {1},Spend={'Finance'}>}CurrQtyReceived * CurrCostLocal))

,'#,##0.00%')

)

)

[smilingjohn]

kushal this is not working

[Kushal_Chawda]

Please share the sample file with expected output