Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
The format for 3 decimals should be:
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),',###,###.000'))),
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),',###,###.000')))),
Niranjan,
What is the error you are getting? Syntax error?
Regards,
Siva
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
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
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
Hi Siva,
i have attached sample app,
can you please check where im doing wrong or any syntax changes.
best regards,
niru
Hi Anil,
i have posted sample app can you please take a look and let me know if any syntax missing.
best regards,
Niru
Can i know which dim you are getting trouble?
Hi, second expression im getting error there im developing the code, Thanks
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