SUM with aggregation with an other column

[Anonymous]

Hello everyone,

One more problem...

Only one table here! These are the list of inscriptions to session and formation (a formation MAY BE included sessions or not). A formation and a session has an id (the same column and the same table).

N°Session  N°Reservation N°SessionParent N°InscriptionParent  NbDaysSession NbDayFormation

1                 4000               x                           x                               1                        x

1                 4001               10                         4001                         1                        1

10               4001               x                           x                                x                        1

...

So, I would like a column with the number of days for each "session" (or formation).

On my session 10, I would like a result => 1 day (or more if I got many N°SessionParent=10 on the rest of my table)

Thank you all,

[v-yulgu-msft]

Hi @Anonymous,

Above table is the source dataset, right? Which is the formation field? And can you please describe why the results of NbDayFormation are x, 1, 1 in above three rows?

Best regards,

Yuliana Gu

[Anonymous]

Sorry,

my translation was not fine..."formation" (in french) is a training.

One people can have an inscription either on a session (only the session) or on a training (included this session an others session).

Is it clearer?