Only with If statement

[manu1512]

Hi all,

Can any one tell me the function of only ? and what does this function is doing in below expression

ONLY({<Well.Name=>}IF(Well.Name='HW08',TW_SP_BO.Reservoir_Pressure))

if i am removing ONLY({<Well.Name=>} then expression is giving me null values.

Please help

Regards

Manu

[Anil_Babu_Samineni]

This should work, Even if you remove Only() and Degrade Field? Aren't you?

IF(Well.Name='HW08',[TW_SP_BO.Reservoir_Pressure])

[sunny_talwar]

I think the only purpose here is to be able to use set analysis here... have you made a selection in Well.Name field when it turns to null?

[olivierrobin]

hello

extract from help

Only() returns a value if there is one and only one possible result from the aggregated data. If the records

so if it returns null, it is because theri is more that one value in Well.Name

[manu1512]

Thanks sunny its works after selecting welll name