any one pls let me know how this logic is working, any one pls let me know how this logic is working

[Anonymous]

If(vLanguage = 'EN',

If(%Condition_WellCluster_EN = 'Well_Head_Pressure', ONLY({<Well.Name={'BW 17 A'}>}TW_SP_BO.Well_Head_Pressure)

),

If(%Condition_WellCluster_DE = 'Well_Head_Pressure', ONLY({<Well.Name={'BW 17 A'}>}TW_SP_BO.Well_Head_Pressure)

)

)

, '#.##0,'& Repeat('#', 2))

[shiveshsingh]

It is If, then else condition

IF condition - If(vLanguage = 'EN',

THEN CONDITION -

If(%Condition_WellCluster_EN = 'Well_Head_Pressure', ONLY({<Well.Name={'BW 17 A'}>}TW_SP_BO.Well_Head_Pressure)

)

ELSE -

If(%Condition_WellCluster_DE = 'Well_Head_Pressure', ONLY({<Well.Name={'BW 17 A'}>}TW_SP_BO.Well_Head_Pressure)

)

)

final value ---   #.##0,'& Repeat('#', 2))

[datagrrl]

This might be helpful in understanding this:

How to use - Only()

[effinty2112]

Hi Adarsh,

The expression boils down to

If(Well.Name={'BW 17 A'} AND

(%Condition_WellCluster_EN = 'Well_Head_Pressure' OR %Condition_WellCluster_DE = 'Well_Head_Pressure')

, W_SP_BO.Well_Head_Pressure)

cheers

Andrew