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
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
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.
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
close the thread by marking helpful or correct, if the issue is resolved.
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
Hi Niranjan, what FCT_SETUP_ID is not working as expected?. I didn't see any issue.
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
Hi, I know, but wich one is not working as expected? 5795577? 5805456?... Please post an image of the table wich value shows incorrect.
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
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'