Skip to main content

Hi, i want to build an OLAP-Table with the following columns: VKONT (contract account), BETRH (amount) and FAEDN (net due Date). How can i sum up BETRH in the Table, when there are different results for BETRH and FAEDN for each VKONT? Thanks! Dominik

Just add all three columns in your Olap table i.e. as follows

 

VKONT 

SUM(BETRH)

FAEDN 

 

Olap table does a group by automatically, hence giving you the result. Hope this helps.


Hi Abishek, unfortunately not. I'll try to explain my problem in a better way! There is one specific VKONT in this table, but related to this Account, there are several payments (BETRH) listed. For a better overview, i had summed up the payments (BETRH), so there is only one line for each Account with the summed up amount of all payments. And now to the Problem. Each payment (BETRH) has an specific net due date (FAEDN). In the moment when I add this column to the table, the sum funktion doesn't work any longer. It's because the formula can't summarize the diffenrent dates in one field. My goal is, to only show the latest net due date in this. Is that even possible? Thanks! Dominik


Try the following

 

VKONT 

SUM(BETRH)

MAX(FAEDN)


Hi Dominik,

 

try it with Pull Up aggregations (PU_*): https://docs.celonis.com/en/pull-up-aggregation.html

e.g

 

PU_SUM(<case_table>, table_name.BETRH)

PU_LAST(<case_table>,table_name.FAEDN)


Reply