Rep 03 Module

PoojaGupta
Occasional Contributor

Rep 03 Module

Hi

I have a confusion in Sum Function:

 

why 'SYS08 Employee Details'.Country is used as cross function in Sum formula of Rep 03 module.

Screen Shot 2021-06-13 at 6.57.45 PM.png

 

Thanks

-Pooja

2 ACCEPTED SOLUTIONS

Accepted Solutions
anand.shekhawat
Super Contributor

Re: Rep 03 Module

Hi @PoojaGupta ,

 

SUM is used here because we want the costs to be calculated on the basis of Country(dimension of REP.03 Module). For further clarification on how to use SUM function click here

 

I hope it helps.

 

~Anand

View solution in original post

ChrisHeathcote
Community Boss

Re: Rep 03 Module

@PoojaGupta 

The best way to describe why a SUM is required here is to think of the Country property as a way to allocate costs from those which are derived for each employee to those derived by country.

 

The mapping bridges the gap and allows the calculation engine to match each employee into their respective country. The calculations then sums each value from one dimension into the other ( employee sums into country ).

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA

View solution in original post

3 REPLIES 3
anand.shekhawat
Super Contributor

Re: Rep 03 Module

Hi @PoojaGupta ,

 

SUM is used here because we want the costs to be calculated on the basis of Country(dimension of REP.03 Module). For further clarification on how to use SUM function click here

 

I hope it helps.

 

~Anand

View solution in original post

ChrisHeathcote
Community Boss

Re: Rep 03 Module

@PoojaGupta 

The best way to describe why a SUM is required here is to think of the Country property as a way to allocate costs from those which are derived for each employee to those derived by country.

 

The mapping bridges the gap and allows the calculation engine to match each employee into their respective country. The calculations then sums each value from one dimension into the other ( employee sums into country ).

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA

View solution in original post

PoojaGupta
Occasional Contributor

Re: Rep 03 Module

Thanks a lot!