600
In SSRS i am trying to create a expression that counts all records that have schedued end after today. How can is this possible?
=Count(IIF(Fields!scheduledendValue.Value <= Today, 1, 0))
Many thanks for help
*This post is locked for comments
Hi martin2000,
I can personally suggest you to use 'Sum' function instead of Count because count will fail in case if "Fields!scheduledendValue.Value" return null.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (