There are several ways to acomplish this.
Example:
COUNT ( IF ( [FrameworkField] <= 2700 ) THEN (1) ELSE (0) ) or
Example:
CASE WHEN ( [FrameworkField] <= 2700 ) THEN (1) ELSE (0) END
Personal techlog from PC1MH
Stuff you will not find in the manual.
Tricks, hacks and discoveries in a journey through the world of technology.
COUNT ( IF ( [FrameworkField] <= 2700 ) THEN (1) ELSE (0) ) CASE WHEN ( [FrameworkField] <= 2700 ) THEN (1) ELSE (0) END
0 reacties:
Post a Comment