[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 202
  • Last Modified:

Syntax issue with query field in query designer

How should this read?

BuyerCommPending: Sum([HH Sale $ Commission] If [Pending]=True)
0
SteveL13
Asked:
SteveL13
1 Solution
 
Rey Obrero (Capricorn1)Commented:
try this, if [pending] is true, get the sum of field [HH Sale $ Commission]


BuyerCommPending: Sum(IIf([Pending]=True,[HH Sale $ Commission],0))
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now