majapa
Last Activity: Jan 10 '10, 11:40 PM
Joined: Jan 10 '10
Location:
-
Groovy Nico. Thanks for helping out a newb like me... I'll work on this! -
Adding another layer of criteria on top of an existing DSum
To start, here is my DSum expression:
Develop: Nz(DSum("[DB_" & [CSOs].[Name] & "] + [Ben_" & [CSOs].[Name] & "]","CSO","[Strategic Planning]='Ability to Develop'")*-1,0)
I actually have 4 of these, each one with a different option for [Strategic Planning].
For more context, the [CSOs].[Name] part is drawing from a separate reference table which cycles...
No activity results to display
Leave a comment: