@Anjaleen Davidson i tried adding Contract and receive the same results getting a error message when i click on the QTY to bring that record up @hhy38 i currently have the matrix for all of these i was trying to reduce the size of my lobby by combining them all into a list, everything works except for i cant navigate to the bad records
@Bhagya Wickramasinghe , here is screen shot of lobby element designer
@Tomas Ruderfelt @ShawnBerk Thank you both, both suggestions worked i knew it was somthing simple thank you again
Thomas Ruderfelt In some cases the last count date is blank untill the part has been counted thank you for the help seems what you provided will work Thank you again
Thank you everyone for your help
@Dumeesha Wanigarathna , I tried to click your link you provided and it says i do not have access to view content
thank you looks like it will work for what i am trying to do. Thank you again
I have it written like thisCONTRACT IN ('$SITE$') and But this is what i get from my element when i try to put C0158,C0152 on the lobby page
It is eluding me as well, when ever it seems so simple it is so hard ha ha ha
@EntNadeeL and @william.klotz Didnt even notice the space, it works now thank you both for your help
@william.klotz Still getting the same error as above, told ya this one was fighting me LOL &AO.Distribution_Order_API.Get_ Dist_Order_Coordinator(ORDER_NO)
Here is Screen Shot and Attachment
Sir, i do not have a Developer screen like yours, i am working strictly out of the Data Source Designer, i am failry new to all of this and have learned alot and received alot of help on this site. i do not see any comma’s
When i try it like that i get the below error message
Thank you everyone, it does save with out the string, so i just need to find a away to shorten it. Thank you again
I changed it to the below and it is working now, thank you for all your help (DECODE(state, 'Planned', 1, 'Released', 2, 'Reserved', 3, 'Picked', 4, 'In Transit', 5, 'Arrived', 6, 'Received', 7))
I changed it to State and now get the below
Error when usingorder by case when state = 'Planned' then 1when state = 'Released' then 2when state = 'Reserved' then 3when state = 'Picked' then 4when state = 'In Transit' then 5when state = 'Arrived' then 6when state = 'Received' then 7
Error when usingDECODE(objstate, 'Planned', 1, 'Released', 2, 'Reserved', 3, 'Picked', 4, 'In Transit', 5, 'Arrived', 6, 'Received', 7)
@paul harland , @Tomas Ruderfelt Gentlemen thank you, i have tried both your ways and both work in the Data Set Preview, how ever when i build the element it will not take using either way, here is screen shot of the X i get when i preview, any thoughts or suggestions as to why it wont take
Thank you not sure why that didn’t cross my mind you helped me one earlier using the same set up, thank you again
@paul harland Thank you for your help with this one greatly appreciated
is there a way to get it to round to nearest whole number, i think that is what is throwing me off
Here is what i get, looks like it worked except the percent doesnt look right
@paul harland I tried to update how you suggested for the first one and got the below message For the third one i am actually taking that one off that was a trial that i dont need if i get the other two to work.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
