Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Age calculation

I have a sample table, in that i sales id i need to create the age for the sales id's as per the status if the status is open From "Created Date" till Today  ; If CLOSED (WON or LOST)  From "Create...
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Anonymous Maybe:

    Column = 
  SWITCH(TRUE(),
    [Status] = "Open", ( TODAY() - [Created Date] ) * 1.,
    [Status] = "Won" || [Status] = "Lost", ( [WonLostDate] - [Created Date] ) * 1.
  )
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous Maybe:

Column = 
  SWITCH(TRUE(),
    [Status] = "Open", ( TODAY() - [Created Date] ) * 1.,
    [Status] = "Won" || [Status] = "Lost", ( [WonLostDate] - [Created Date] ) * 1.
  )