Joined: 03 Oct 2014
Online Status: Offline
Posts: 13
Topic: How can I report on a field that doesn't exist? Posted: 30 Mar 2018 at 6:45am
I have a custom table/field that is built into a report.
The formula is as follows: if {APPLICATIONPROPERTY.ITEM_NAME} = "OXLN_DP_SOLD_BY" then {APPLICATIONPROPERTY.APPLICATION_ITEM_VALUE} else ""
The problem is that I have 1 record that is missing in the report because this custom record doesn't exist, so the report skips it. How can I modify the formula to still include the data if this field doesn't exist?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 02 Apr 2018 at 7:00am
Kevlray may be onto something. I assumed your joins were OK.
However, inside the Formula Editor there should be an option (pick list) on how to handle nulls. You can set this per formula.
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
IP Logged
