Hi Friends

[krishna20]

Hi Friends !

I'm having a doubt in applying Nested If expression.My expression is not showing the exact data which is in raw data.Pls check out my expression and help me out ASAP.

=Min({<TP_TXN_TYPE={'POL'}>}if(PROD_CODE='0110',if(TP_SCH_CODE<>'0113',(TR_PREM_LC_1/TR_SI_LC_1)*100)))

[tresesco]

Click on Reply->Use Advanced Editor (top right corner)->Attach (bottom right corner)

[krishna20]

!

[tresesco]

In your attached sample, the expression returns a value .235...

What is your expected result?

[#5]

With tresesco's expression it is working fine. No nulls or anything.

[krishna20]

Commercial Min(TR_SI_LC1) MAX(TR_SI_LC_1) Min Rate Max Rate

                  42000                  394000                   2.17     5.15

                   52900                  395000                   2.33    5.05

                   50000                  161774                   2.48     3.18

all for 2014 year

[krishna20]

Thank you..Tresesco..

[tresesco]

Dear Kalyan,

If it is working for you, please close this thread marking it 'Correct Answer' and please delete this thread: Tresesco