Variance report with absolute and percentages in a single grid

Hi all,

I'm trying to create a basic variance report with LIS as a dimension of parameters and the line items to find the variance. But, the challenge here is that the LIS consists of both absolute numbers and percentages, and the client wants to see the variance in both absolute numbers and percentages respectively. Is there a way to get this in a single grid itself ? client is not ready to split it into separate grids.

Accepted answers

All comments

rob_marshall

@sgk6

You can create a SYS LISS module using your current LISS, create a line item called Multiplier and for the % members, enter a 100, for all others, would be a 1. Then, when you return the data, you multiply by the multiplier in the SYS LISS module. That will get you the correct numbers, but you won't have the % as a suffix.

Badam

Nice workaround for the above problem.

sgk6

Thank you @rob_marshall, I have that worked out, but the challenge is to show the % symbol for these items. Also, even for the YTD summaries, it is just going to be Sum up for these % LIS items too instead of getting an average

rob_marshall

@sgk6

Yep, as I said earlier, I am not sure how you can mix them with the % as a suffix when you are using a LISS the way you are.

What if you keep the above as a "CALC" module, for the "Reporting" module, create new line items which will allow you to format the way you need them to be. In fact, you can create another LISS in the Reporting module and link them to the CALC LISS using a mapping module.

andrewtye

Could try the Report page where you can format based on line item, particularly useful if there's no inputting required.

Badam

@andrewtye , will this be a part of future roadmap for boards and worksheets?

sgk6

Thanks @rob_marshall and @andrewtye! I've currently solved it by using Report pages, but still face a huge limitation to get this working as expected in Boards or worksheet.

It would be great if we've this option available in Boards and worksheets too.

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…