Hello,
I am looking to make a table to table summary field but i am looking to make it for a specific logic. I have a policy that gets updated with a cancel date if the policy gets cancelled. This is working fine but the problem is that if we add another policy because the person wants to reenroll into another policy we only want it summarize the active policy aka the one that does not have a cancel date in it. How would i make the logic to only sumamrize this field as it only allows for me to put the cancel date is not equal to the date then leave the date field empty but then it is not summarizing anything.
see below the logic that i have used that is not working!
------------------------------
Benjamin Brooks
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.