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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.