Formula to add line item from Monthly set up to QTY

Hi Community,

I would like to ask if this is possible. There are 3 modules done but 1 module is set to monthly and the other is set to quarterly. See below for the illustration:

I had to create an illustration since I cannot provide screenshot from the model due to confidentiality.

This is the revenue module.

And then they created another module set to quarterly for the recon.

The idea is to add both yellow cells on th Mar 19 column of the Final Revenue module. So the mar 19 formula in the final Revenue Module would be Revenue Module.Revenue mar19 + Recon to AFS module. Recon to AFS Revenue Mar19. Currently we are not getting the values or getting a circular reference as an error.

Not so sure why they build the model with different modules instead of a single one.

Appreciate if you can provide some ideas on how to execute this one.

Thanks and Regards,

Accepted answers

ManjunathKN

Hi

Bring 2 line items(LI), one with boolean and another with number. now add number formatted line item to your revenue line item and name it as "Revenue Final".
formula for
LI 1 : Quartervalue(Revenue). - Numeric
LI 2: Next(Parent(item(time)))<>Parent(item(time)) - Boolean
LI 3(Revenue final): if not LI2 then Revenue else (LI 1+Revenue) - Numeric

Thanks,
Manjunath

ManjunathKN

Hi

line item 1 in your revenue module(from where you are getting initial quarter data) - keeping month as time period.
Line item 2 keep in your time setting module and bring one more line item in your revenue module.(refer from time setting module)
Line item 3 in your revenue module.

I would suggest to keep all 3 line item in your revenue module.

Thanks

Thanks.

Jsdeloria21

hi,

Is there a way you can provide some screenshot on how this is executed. My apologies for my request.

Thanks in advance,

ManjunathKN

Hi

Below SS will help you
Module 1: quarter data in recon to AFS module.

Module 2: Revenue module.

Thanks,
Manjunath

All comments

ManjunathKN

Jsdeloria21

hi ManjunathKN123,

Appreciate your response, I would like to just clear somethings. like where should I add the 2 line item? on the revenue module, recon with AFS module or the final Revenue module.?

also on the formula if not LI2 then Revenue else (LI 1+Revenue) - Numeric shall I put this on the Final Revenue module?

Thanks for the response,

ManjunathKN

Jsdeloria21

hi,

Is there a way you can provide some screenshot on how this is executed. My apologies for my request.

Thanks in advance,

ManjunathKN

Hi

Below SS will help you
Module 1: quarter data in recon to AFS module.

Module 2: Revenue module.

Thanks,
Manjunath

Jsdeloria21

Hi Manjunath,

THank you very much.

Regards,

Jsdeloria21

hi,

THis issue has been resolved already. THanks for all your input. Appreciate it very much.

Thanks and Regards,

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…