Conditional Count of days to date

[Anonymous]

I have a date when a file was created, but there is a condition based on another column called group that:

if Table[group] = Critical, and the date created>30 days then days should start counting to current date

if Table[group] = High, and the date created>30 days then days should start counting to current date

if Table[group] = Medium, and the date created>60 days then days should start counting to current date

if Table[group] = low, and the date created>90 days then days should start counting to current date

Attached is a sample and my calculation logic

[Greg_Deckler · Accepted solution]

@Anonymous Try:

Column =
  VAR __Today = TODAY()
  VAR __Date = [Date]
  VAR __DiffDays = ( __Today - __Date ) * 1.
RETURN
  SWITCH([Group],
    "Medium", __DiffDays - 60,
    "Low", __DiffDays - 90,
    __DiffDays - 30
  )

[Anonymous]

Thank you @Greg_Deckler I just notices something that I am getting negative count of days if the Added conditinal days is not satisfied yet, How do I correct this

[Greg_Deckler]

@Anonymous Try:

Column =
  VAR __Today = TODAY()
  VAR __Date = [Date]
  VAR __DiffDays = ( __Today - __Date ) * 1.
RETURN
  SWITCH(TRUE(),
    [Group] = "Medium" && __DiffDays >= 60, __DiffDays - 60,
    [Group] = "Low" && __DiffDays >= 90, __DiffDays - 90,
    __DiffDays >= 30, __DiffDays - 30,
    0 //or whatever you want to return in the event none of the conditions are met
  )