Which condition to use

[bharatkishore]

Hi All,

I have 2 tables one table is like

T1:

LOAD Modality,

     Material_Code ,

     PartType ,

     PLANT

FROM

(qvd);

and second table is like

T2:

LOAD Modality,

     [Product Group],

     [System Code],

     [Norm group],

     Global_Norm,

     CN_Norm,

     RUID_Norm

FROM

(qvd);

Now in first qvd i have plant and in that plant i have CN93, ID93 ,Global, RU93 data.

Now in second qvd i have CN_Norm, RUID_Norm and Global.

Now based on first table field plant when it is CN93 i should get sum(CN_Norm) and when it is RU93 i should get sum(RUID_Norm ) and when it is not CN93 and RU93 Global should get sum(Global) .

Can you please help me how can i acheive it.

Thanks,

Bharat

[Anonymous]

Kishore,

Kindly upload the sample application or sample data here. Based on that our community experts will give you reply with possible solution..

Thanks & regards,

Venkata Sreekanth

[bharatkishore]

PFA..

[Anonymous]

Kishore,

I am assuming that , we have to write a if condition inside the expression. Before that we have to create a data modeling based on the Modality field.

Expression:

Sum(If(Palnt = 'CN93' , CN_Norm, If(Palnt = 'RU93' , RUID_Norm,Global_Norm))

Thanks & Regards,

Venkata Sreekanth

[bharatkishore]

Yes i need to write that condition but i don't know how to get the link and right because plant is from one qvd and other norms are from other qvd..

can yu please help..

[Anonymous]

Use the below expression

=Sum(If(PLANT = 'CN93' , CN_Norm, If(PLANT = 'RU93' , RUID_Norm,Global_Norm)))

Thanks & regards,

Venkata Sreekanth

[bharatkishore]

This will not work because CN_Norm is from another qvd..

[Anonymous]

Use the below expression

=Sum(If(PLANT = 'CN93' , CN_Norm, If(PLANT = 'RU93' , RUID_Norm,Global_Norm)))

Thanks & regards,

Venkata Sreekanth