Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

SUM with aggregation with an other column

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 ...
Show and Tell
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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's avatar
    Anonymous
    Not applicable
    8 years ago

    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?