get item numbered list depending on a range of dates

Options
RosarioCaramagno
RosarioCaramagno Member, ALL USERS Posts: 5 New Contributor
in Planning & Modeling

Hi,

I need your help.

I have 3 lists: Product, rate, invoice

 

lists.JPG

and two modules:

mods.JPG

 

rates.JPG

invoices.JPG

 

 

I want to put in invoices.valid rate the max number# of rate list where all following conditions are satisfied:

 

  • Rates.status = true
  • Invoice.Prod name  = rates.prod name
  • Rates.start date < Invoice.Invoice date < rates.end date

 

Can you help me?

Thanks

 

 

Tagged:

Comments

  • RosarioCaramagno
    RosarioCaramagno Member, ALL USERS Posts: 5 New Contributor

    Thanks, but is not clear for me (I'm a beginner in anaplan). 

    Could you expand the condition 
    "IF all conditions THEN ITEM(rate) else BLANK"
    with the modules used from me?

    Thanks a lot.

  • RosarioCaramagno
    RosarioCaramagno Member, ALL USERS Posts: 5 New Contributor

    Sorry but it doesn't work.
    I put your formula in VALID RATE of invoices module that have format="rate list"

    this is the formula
    IF rates.status and

         invoices.prod name = rates.prod name
    then    IF Rates.start date < Invoices.Invoice date  AND 

                   Invoices.Invoice date < rates.end date 

               THEN   ITEM(rates)       

               ELSE Blank

    ELSE blank
    I receive the following error:

    ERROR.JPG

     Have you some suggestion?



  • RosarioCaramagno
    RosarioCaramagno Member, ALL USERS Posts: 5 New Contributor

    Sorry but I suspect that this solution doesn't work because I think that it need an aggretion formula to link two modules;
    Also I need to compare the invoice date of the module INVOICE with a range of dates saved in the module of RULES.

     

    Any other suggestions?

  • RosarioCaramagno
    RosarioCaramagno Member, ALL USERS Posts: 5 New Contributor

    Thanks, 
    I follow your suggestion but I receive an error:

    RosarioCaramagno_0-1608329796370.png

    and RATE LIST have a top level:

    RosarioCaramagno_1-1608329944751.png

     

    I don't understand where is the error!

    Thanks to help me.
    What I wrong?

     

Categories