6 Replies Latest reply: Aug 13, 2013 2:12 AM by Peter Schulz RSS

    How to show next process (descr.)

    Peter Schulz

      Hi

       

      I have 2 tables Orders and suborders.

       

      I have a straight table with orders as dimension and some expressions. And what I want to show is the description of the next suborder.

      I think I have to create a field in the script in the Orders table, which saves this for me.

       

      I don't find a way to show it in the table. I can show the max(ID_suborder) and the number of suborders to come. So i could calculate the ID_suborder for the next suborder. Something like =max(ID_suborder) - open_suborders + 1 ...

       

      open_suborders = count(IF(Status=1,suborder))  ... just for the record.

       

      But even with this number I'm not able to show the description.

       

      I tried this IF(max(ID_suborder) - open_suborders + 1 = ID_suborder, Description,'No Orders')  ... Its not obvious for me why this don't works.

       

      Do I have to code this into the script and generate an extra field? I can't believe that this can be so hard to show.

       

      I think it should be the first ID_suborder with Status=1

       

       

      Thank you for any hints..