Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Running Total
- Thread starter ashark
- Start date
synapsevampire
Programmer
I recently learned that when summing (and perhaps other aggregates) a RT, CR can return NULL, a count RT doesn't do this...
Create a formula for display purposes using your created RT to check for NULL and change it to 0 if required:
if isnull({#MyRunningTotal}) then
0
else
{#MyRunningTotal}
-k kai@informeddatadecisions.com
Create a formula for display purposes using your created RT to check for NULL and change it to 0 if required:
if isnull({#MyRunningTotal}) then
0
else
{#MyRunningTotal}
-k kai@informeddatadecisions.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question