Expression Error

[NavinReddy]

Dear Experts Good Evening,

i have used two match conditions in my expression to get different decimals for specified fact number,

one match fiction working fine , the highlighted match function not working.

please suggest me i have tried different ways i didn't get any solution.

Many Thanks,

Niru

[Siva_Sankar]

Niranjan,

What is the error you are getting? Syntax error?

Regards,

Siva

[NavinReddy]

Hi Siva,

Thanks for your reply,

i have tried with two match functions to get different format decimal , one match function working fine as expected.

second match function its not working not sure if any syntax error or any other way to resolve this issue.

Thanks,

Niru

[Siva_Sankar]

Looks like you are missing comma or brackets somewhere in the first part of the expression. You can narrow down by writing part by part expression or try uploading your qvw file here.

--siva

[Anil_Babu_Samineni]

Can you please post the Error which you got, Clue is bit important. Meantime, Please post that Expression only in the HTML format. It's looking image. How to copy that code

[NavinReddy]

Hi Siva,

i have attached sample app,

can you please check where im doing wrong or any syntax changes.

best regards,

niru

[NavinReddy]

Hi Anil,

i have posted sample app can you please take a look and let me know if any syntax missing.

best regards,

Niru

[Anil_Babu_Samineni]

Can i know which dim you are getting trouble?

[NavinReddy]

Hi, second expression im getting error there im developing the code, Thanks

[Siva_Sankar]

Hi Niranjan,

why you are using same code twice for same condition..

if(Match(FCT_SETUP_ID,5795577,5805456,5805436,5805437,5805457,5794739),

if(EELE_TYPE_NM_SIGN='$',

if(ELE_VALUE_TYPE_CD = 'PCT',Num(MaxString({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}FCT_ACTL_VALUE_QT)*100,'##.000%'&'  ')&'',

if(ELE_VALUE_TYPE_CD = 'QTY','$'&Num(MaxString({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}FCT_ACTL_VALUE_QT),',###,###.0'))),

if(ELE_VALUE_TYPE_CD = 'PCT',Num(MaxString({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}FCT_ACTL_VALUE_QT)*100,'##.000%'&'  ')&'',

if(ELE_VALUE_TYPE_CD = 'QTY',Num(MaxString({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}FCT_ACTL_VALUE_QT),',###,###.0')))),

if(EELE_TYPE_NM_SIGN='$',

if(ELE_VALUE_TYPE_CD = 'PCT',Num(MaxString({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}FCT_ACTL_VALUE_QT)*100,'##.00%'&'  ')&'',

if(ELE_VALUE_TYPE_CD = 'QTY','$'&Num(MaxString({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}FCT_ACTL_VALUE_QT),',###,###.0'))),

if(ELE_VALUE_TYPE_CD = 'PCT',Num(MaxString({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}FCT_ACTL_VALUE_QT)*100,'##.00%'&'  ')&'',

if(ELE_VALUE_TYPE_CD = 'QTY',Num(MaxString({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}FCT_ACTL_VALUE_QT),',###,###.0'))))))

which number format you want for which condition, you if statement is repeating