## SUM with Group Number

Occasional Contributor

## SUM with Group Number

Hi I want to sum Orders with Group Number.

The point is Group Lineitem is not formatted List, is Number Formatted.

 1-Nov 2-Nov 3-Nov 4-Nov 5-Nov 6-Nov ・・・ Group 1 2 3 1 2 3 Order 100 200 300 400 500 600 Odrer(Sum) 500 700 900 500 700 900

I tried Rankcumulate or Sum Functions, But I can't Solve this.

4 REPLIES 4
Occasional Contributor
Hyudolee,

Can I understand the desire to keep Group number formatted? Is this an imported field?

I don't see a way around creating a list.
1. Create Group List with codes the same as the number
2. Add a line item in this module above and do a FINDITEM('Group List' , Group) so you have a line item list formatted by "Group"
3. Create another module that sums up the amounts based on the timescale you choose.
4. Order(Sum) will reference the module created in Step #3.

Let me know what questions you have.
Occasional Contributor

Hi, @sourjyar .

Thanks for replay.

But in this situation, Group determined  by Time.

(Like weekday)

If I want to aggregate Order by Group, I have to make a module(Time & Weekday List).

We cannot aggregate Time to Group in Anaplan.

It will consume much memories.

 1-Nov 2-Nov 3-Nov 4-Nov 5-Nov 6-Nov ・・・ Group 1 2 3 1 2 3 Order 100 200 300 400 500 600 Odrer(Sum) 500 700 900 500 700 900
Occasional Contributor
Let me take a step back and ask a few questions to understand the context better.

1. How many groups can there be in total? Does Nov 7th start back at 1 again?

2. When you aggregate your Order (Sum) line item..are you looking at the entire timescale or just one week or just one month? What is the basis of that aggregation?
Occasional Contributor

1. How many groups can there be in total? Does Nov 7th start back at 1 again?

>> 31Groups( = month)

I will use this group as dynamic cycle. It will change by time cycle( month, week)

2. When you aggregate your Order (Sum) line item..are you looking at the entire timescale or just one week or just one month? What is the basis of that aggregation?

>> 1months.

I think we can use day List instead of Time(Day), and save memories.