Variation Column that results "%" or "pts" in the same cell depending the account selected

diogocorazza
New Contributor

Variation Column that results "%" or "pts" in the same cell depending the account selected

Hello Everyone

 

I'm trying to find a creative way to report the line items in rows and columns with amounts, variance $ and variance %/pts (the last in the same cell). In the screenshots below is the ideal formatting. Unfortunately Anaplan allow me to use only one Line Item, so I cannot create customized columns and be "creative" with a single column for the Variance in % or Pts depending the line item selected. If I choose to use a LIS for accounts and create this columns as line items I have another problem, because I need to use the Collect function and it return as a number unique format, but I need some accounts in amounts and others in % and still need to compare IF amounts in %, OR IF % in pts. I think I need to know if this is impossible in Anaplan and reports the way we not like or if anyone has a creative way to report in the ideal model below. (the team that helped us developing our project told me it is impossible, so he created 2 reports: one for Amounts and variance in % and other for % and variance for pts).

The final problem is that I would like to report in sequence the corresponding accounts, even if need to mix Amounts Accounts or % accounts in the the report.

Thank You

 

As is today:

REP1 

Snag_2061248.png

Snag_2064137.png

 

REP2

Snag_206d8d4.png

Snag_208f2cb.png

 

Ideal: 

 

Snag_20c1884.png

3 REPLIES 3
rob_marshall
Moderator

Re: Variation Column that results "%" or "pts" in the same cell depending the ac

@diogocorazza 

 

First, please remove the emoji's from the model as these could have some fairly serious consequences (performance, losing the model because different browsers interpret the emoji's differently, etc.)

 

Second, while it is not exactly what you want in the final result, I would create a Line Item Subset (LISS) with the line items being Current Year, Previous Year, Variance $, and Variance %/pts.

 

As for how to do create the LISS, you can get more information here:

 

Hope this helps,

 

Rob

 

 

Hope this helps.

ChrisHeathcote
Community Boss

Re: Variation Column that results "%" or "pts" in the same cell depending the ac

@diogocorazza 

It is not possible to use different formatting in both columns and rows within the same module!

Your implementation partner is correct and the solution they offered in building two different reports is the only option that I am aware of.

However, I am happy to be enlightened if there is an alternative.

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
diogocorazza
New Contributor

Re: Variation Column that results "%" or "pts" in the same cell depending the ac

Thank You @ChrisHeathcote  and @rob_marshall 

 

Yes, that's what I would like to know because I'm almost a week trying to solve this. If this is not possible I can move on and accept the way it is.

 

Thanks!