Incoherent summary when period is quarters, year or even YTD

Hello,

I'm really at the beginning of the journey of being Model Builder so I'm afraid that what I'm to ask you is really basic, but hope to find help and the learn more .

The context of the issue is that the following line item is looking for the customers that have 0 revenue in the current month, and if is true, then it shows the revenue from the previous month.

Month by month it is coherent, but when the period is a quarter, FY or even YTD, it explodes and so far from the reality.

I've tried multiple combinations of summaries, but no luck until now, to discover how to adjust the formulas, in order to simply add the monthly amounts and not check if the condition is met.

Thank you !

Accepted answers

All comments

TimothyThomas

Hi @rfilip ,

Do not be afraid to ask here, no matter how basic! From your screenshots, your line items seem to make logical sense, and I would expect the default summary method to work for what you are describing. Could you possibly attach a screenshot of the line item in default view so we can see the problem occurring?

Thanks,

Timmy

ManjunathKN

Hi

Have you tested with time summary as closing Balance?

let me know if that did not work for you. we can use ratio as summary to resolve the issue.

Thanks,
Manjunath

rfilip

Hello @TimothyThomas,

Thanks in advance for helping me !

> Example for Jan 22, Up sell has 7 ;

> For Feb the same line has 7, but recorded as being recurring;

According to conditions set, both Jan and Feb are correct.

> However, Mar 22 data is not available, so the Revenue in current Month = 0, so the formula works fine and it returns the 7 from the last month, as being loss revenue in Mar 22. But this has an huge impact on the quarter summary, year and so on.

> Q1 22, shows the 2 correct amounts for Jan and Feb, but it also shows the amount for Mar (which is not real).

So now I'm thinking that maybe I should add a condition on the period, to check if there is data or not, before calculating the amounts. Any help, of how I can do that, will be extremally appreciated it.

rfilip

Hello ManjunathKN,

Thank you for your answer !

The summary I need is to have JAN + FEB + MAR = quarter 1, so from my understanding this option will show only the value for MAR.

ManjunathKN

Hi

Create 3 Line items,

1. Loss Revenue (-) Sum Data - formula -> If Up Sell>0 then Loss Revenue (-) else 0
2. Loss Revenue (+) Sum Data - formula -> if up sell>0 then Loss Revnue (+) else 0
3. Denominator - Formula - "1"

All three are number formatted line item.

now, in your Loss Revenue (-) line item, Set Time summary as Ratio -->New line item 1/New line item 3
in your Loss Revenue (+) line item, Set Time summary as Ratio-->New line item 2/New line item 3.

Hope this helps,

Thanks,
Manjunath

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…