1 Reply Latest reply: Nov 30, 2011 7:16 AM by Brian Rzeznik RSS

    calculalte the progress on More Date

      Good Morning,

      I hope someone can help me :-)

      I need to calculate the progress(cumulate and relative) % of some document based on Document SCHELUDD_DATE respect to a specific CutOff Date.

      I have two table:

      1)DOC_TABLE:

      DOCU_NUM,

      PROGRESS,

      SCHEDULED_DATE

       

      2)CUTOFF_TABLE:

      CUTOFF_DATE

       

      For example if I have only One 'Cut-Off Date' the expression is if(SCHEDULED_DATE<=CUTOFF_DATE,PROGRESS,0) /100

       

      But if We have more CUT_OFF_DATE how we can calculate the Progress for all Date?

      For eample i should have a table as the attachment.

       

      Is It possible?

       

      Many thanks and best regards :-)