Forum Discussion

Dane's avatar
Dane
Helper I
4 years ago
Solved

Token Comma Expected Error

I am trying to add a custom column in a table to calculate the difference between the date when an order is closed against when the order was opened.  Below is my formula.  I am getting a Token Comma...
Need Help
  • selimovd's avatar
    selimovd
    4 years ago

    Hey Dane ,

     

    right after the if you have 2 brackets Orders[[ClosedDate].

    Can you try to remove one of them?:

    New Column =
IF(
    Orders[ClosedDate] > 0,
    DATEDIFF(
        Orders[ClosedDate],
        Orders[Date],
        DAY
    ),
    DATEDIFF(
        TODAY(),
        Orders[Date],
        DAY
    )
)

     

    As you just want to get days you can also just subtract the the dates:

    New Column =
IF(
    Orders[ClosedDate] > 0,
        Orders[Date] - Orders[ClosedDate],
        Orders[Date] - TODAY()
)

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

     

selimovd's avatar
selimovd
Most Valuable Professional
4 years ago

Hey Dane ,

 

right after the if you have 2 brackets Orders[[ClosedDate].

Can you try to remove one of them?:

New Column =
IF(
    Orders[ClosedDate] > 0,
    DATEDIFF(
        Orders[ClosedDate],
        Orders[Date],
        DAY
    ),
    DATEDIFF(
        TODAY(),
        Orders[Date],
        DAY
    )
)

 

As you just want to get days you can also just subtract the the dates:

New Column =
IF(
    Orders[ClosedDate] > 0,
        Orders[Date] - Orders[ClosedDate],
        Orders[Date] - TODAY()
)

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis