Forum Discussion

BachFel's avatar
BachFel
Icon for Helper II rankHelper II
8 years ago
Solved

Calculate, sum? need help with a formula

Following problem: in the table LN[Leistungsbeschreibung] can be more than one row with the text "Objektbegehung", per ID. i.E.:   ID          Leistungsbeschreibung       Datum  111        Objek...
Need Help
  • Floriankx's avatar
    Floriankx
    8 years ago

    Hello,

     

    I used ID instead of KostElementID, might be a little confusing because you have several IDs

     

    FILTER(LN;LN[KostElementID]=EARLIER(KontElement[KostElementID]) hopefully works now.

Floriankx's avatar
Floriankx
Icon for Solution Sage rankSolution Sage
8 years ago

Hello,

 

you wrote:

FILTER(LN;KontElement[ID]=EARLIER(KontElement[ID])

instead of

FILTER(LN;LN[ID]=EARLIER(KontElement[ID])

 

Please correct and let me know

BachFel's avatar
BachFel
Icon for Helper II rankHelper II
8 years ago

Hello,

 

I wrote

 

FILTER(LN;KontElement[ID]=EARLIER(KontElement[ID])

instead of

FILTER(LN;LN[ID]=EARLIER(KontElement[ID])

 

 

because in the table LN there is now column with the expression you took.

 

 

  • Floriankx's avatar
    Floriankx
    Icon for Solution Sage rankSolution Sage
    8 years ago

    Hello,

     

    I used ID instead of KostElementID, might be a little confusing because you have several IDs

     

    FILTER(LN;LN[KostElementID]=EARLIER(KontElement[KostElementID]) hopefully works now.

  • v-xjiin-msft's avatar
    v-xjiin-msft
    Icon for Solution Sage rankSolution Sage
    8 years ago

    Hi BachFel,

     

    Please no noticed that generally EARLIER() function is used in a calculated column, not a measure.

     

    Thanks,
    Xi Jin.