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

[NavinReddy]

Hi Siva,

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

for this statement im trying to adding on e additional decimal to specified number

ManyThanks,

Niru

[Siva_Sankar]

Niranjan, as per the match condition and if conditon below based on the field value of ELE_VALUE_TYPE_CD , the formatting works as expected. not sure how you are saying it incorrect. sorry.

[NavinReddy]

Yes you're correct for matting working fine,

but im working on adding additional decimals to listed fact number.

sorry for confusion

Many Thanks,

Niranjan

[Siva_Sankar]

close the thread by marking helpful or correct, if the issue is resolved.

[NavinReddy]

Hi Siva,

Sorry i have created for thread adding additional decimals to the fact number.

not sure how to resolve issue

Thanks in Advance,

Niranjan

[rubenmarin]

Hi Niranjan, what FCT_SETUP_ID is not working as expected?. I didn't see any issue.

[NavinReddy]

Hi Ruben,

Good Morning thank you very much for your reply,

highlighted match function FACT_SETUP_UP IDs im trying to adding the additional decimals.

i am not able to do.please help me.

Many Thanks,

Niranjan

[rubenmarin]

Hi, I know, but wich one is not working as expected? 5795577? 5805456?... Please post an image of the table wich value shows incorrect.

[NavinReddy]

All below listed ids not working for these facts i want to display 3 decimals,

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

Best Regards,

Niranjan

[rubenmarin]

What you have in that match is:

If ELE_VALUE_TYPE_CD='QTY' --> 1 decimal

If ELE_VALUE_TYPE_CD='PCT' --> 3 decimals

If you want 3 decimals also when ELE_VALUE_TYPE_CD='QTY' you should set the format of that condition with 3 decimals:

'###,###.0' --> to --> '###,###.000'