get item numbered list depending on a range of dates

RosarioCaramagno

Hi,

I need your help.

I have 3 lists: Product, rate, invoice

 

and two modules:

 

 

 

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

 

 

RosarioCaramagno

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

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:

 Have you some suggestion?

RosarioCaramagno

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

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

and RATE LIST have a top level:

 

I don't understand where is the error!

Thanks to help me.
What I wrong?