- Community
- :
- About RosarioCaramagno
Ask the Community
-
Ask a QuestionGet answers to platform specific questions from Anaplanners everywhere.
-
Suggest an IdeaShare ideas for platform improvements, training, the Community, and more.
-
Get Training HelpComplete your training with support from the experts.
-
Contribute ContentWorkshop content, submit for approval, and contribute best practices to the Community.
-
Connect with CommunityShare feedback, ask questions, and get support from the Community.
About RosarioCaramagno
since
09-11-2020
Thursday
RosarioCaramagn
New Contributor
Activity Feed for RosarioCaramagno
- Posted Re: get item numbered list depending on a range of dates on Anaplan Platform. 12-18-2020 04:21 PM
- Posted Re: get item numbered list depending on a range of dates on Anaplan Platform. 12-17-2020 01:13 PM
- Posted Re: get item numbered list depending on a range of dates on Anaplan Platform. 12-17-2020 11:26 AM
- Posted Re: get item numbered list depending on a range of dates on Anaplan Platform. 12-17-2020 10:31 AM
- Posted get item numbered list depending on a range of dates on Anaplan Platform. 12-17-2020 08:57 AM
- Posted take a value from another module on Anaplan Platform. 11-02-2020 08:28 AM
6
Posts
0
Kudos
0
Solutions
12-18-2020
04:21 PM
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?
... View more
12-17-2020
01:13 PM
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?
... View more
12-17-2020
11:26 AM
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?
... View more
12-17-2020
10:31 AM
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.
... View more
12-17-2020
08:57 AM
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
... View more
Labels:
11-02-2020
08:28 AM
I have a module named AAA like this: lower upper Payout rate total invoice status tranche 1 0 500 0% $ 850 0 tranche 2 500 900 2.5% $ 850 1 tranche 3 900 1200 3.0% $ 850 0 tranche 4 1200 1500 3.5% $ 850 0 And another module named BBB: Quantity Values $ Rate Applied product 1 48000 $ 250 ? product 2 $ 210 ? product 3 $ 200 ? product 4 $ 190 ? TOTAL $ 850 I want to put in list item of BBB “Rate Applied” a formula that take the value of “Payout Rate” of module AAA based on the status (only one is <> 0). For example, if status is checked in “tranche 2” the “Payout rate” is 2.5%, so the value of “Rate” in BBB should be 2.5% (in all rows). Which formula do it? Thanks in advance.
... View more
Labels: