Joined: 04 Nov 2009
Online Status: Offline
Posts: 123
Topic: Help with formula if value does not exist in table Posted: 04 Dec 2009 at 11:28am
Hi all, I am fairly new with CR 11 and doing a lot of learning along the way. I have a report that is pulling some numerical fields from two different tables. One of the tables is an optional field and may or may not have a number connected to a record. I will try to diagram below. What I am finding if is there is no record in the second table I am not getting a value from my formula instead of just getting the value from table 1. How can I setup my formula so if no record exists in table 2 then use the value from table one as the result.
current Delima Record ID Table1 Table2 formula result
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum