0

Calculate records with dropdown value

Cant seem to get my if statements working.

I just want to sum up the 'Total' field of my records that have the dropdown (Status) set to 'Sent'.

Any help appreciated!

1 reply

null
    • Nick
    • 5 yrs ago
    • Reported - view

    Try this:

    sum((select TableName)[text(Status) = "Sent"].Total)

Login to reply

Content aside

Categories

View all topics
  • 5 yrs agoLast active
  • 1Replies
  • 932Views