If condition issue

[dineshm030]

Hi Legends,

We are facing IF condition kindly help me.

Expression:

sum({<Day_of_Week=,Version_Desc = {'Target'},SalesType_Key={'1'},SalesPeriod = {1},CP_Team_Flag=,Product_Group_Code -= {'ENCG','ENTG'}>}Sales_Value)/1000

We are using above expression we get the value of DEPURA in the report.

Expression:

If(BU = 'Women Health',

sum({<Day_of_Week=,Version_Desc = {'Target'},SalesType_Key={'1'},SalesPeriod = {1},CP_Team_Flag=,Product_Group_Code -= {'ENCG','ENTG'}>}Sales_Value)/1000,

sum({<Day_of_Week=,Version_Desc = {'Target'},SalesType_Key={'1'},SalesPeriod = {1}>}Sales_Value)/1000)

Where as We are using above expression we do not get the value of DEPURA in the report.

[arvind_patil]

Hi Dinesh,

Pelase try below:

If(Wildmatch(BU, 'Women Health'),

(sum({<Day_of_Week=,Version_Desc = {'Target'},SalesType_Key={'1'},SalesPeriod = {1},CP_Team_Flag=,Product_Group_Code -= {'ENCG','ENTG'}>}Sales_Value)/1000),

(sum({<Day_of_Week=,Version_Desc = {'Target'},SalesType_Key={'1'},SalesPeriod = {1}>}Sales_Value)/1000))

Thanks,

Arvind Patil

[dineshm030]

it doesn't work arvind....

[arvind_patil]

Hi Dinesh,

I am sure there is Bracket issue  kindly check  without division.

If(BU = 'Women Health',

sum({<Day_of_Week=,Version_Desc = {'Target'},SalesType_Key={'1'},SalesPeriod = {1},CP_Team_Flag=,Product_Group_Code -= {'ENCG','ENTG'}>}Sales_Value),

sum({<Day_of_Week=,Version_Desc = {'Target'},SalesType_Key={'1'},SalesPeriod = {1}>}Sales_Value))

Thanks,

Arvind Patil

[dineshm030]

Again it does not work arvind......

[tresesco]

This could be because- BU 'Women Health' there is no sales for Depura. Could you share your app sample?