Formula Help

[grecon]

I have a formula

if{CUSTHIST.CALL_TYPE}=0 then "CALLED"

but it brings all the other call types as well as information that doesn't have a call type assigned. All I want is the call types "0" and nothing else. What do I need to add to this formula to strip away everything else.
Thanks

 

[kray4660]

Are you using this formula to filter the data (i.e, is it in the selection criteria in some manner)?


It should (provided the data is correct), show the word CALLED when {CUSTHIST.CALL_TYPE} = 0 and not show anything if {CUSTHIST.CALL_TYPE} has any other value.

 

[fisheromacse]

if you are using this in the selection criteria/select expert, you do not need the if or the then portions. This would only pull data where your field is equal to zero.
{CUSTHIST.CALL_TYPE}=0

if you are using this in the details section, what you have appears correct. you could add an 'ELSE ""', but it should not make a difference. This would pull all the data, without regard to the value of your field, and show a blank if the type was not equal to zero.
if{CUSTHIST.CALL_TYPE}=0 then "CALLED" ELSE ""

 

[grecon]

Hi I don't have it in the selection criteria because my report is a collections report and I just wanted to add the extra piece of information ie showing customer was called about an invoice. Not all the records will have that they were called so I can't use it as a selection. I am just trying to add that additional infomation to the report but when I do it brings in blank fields as well as the other call types, it is also duplicating all other info so I must have something linked wrong causing the duplication.

Simply put I just wanted to add the field Call Type to the report but not have all the call types listed since the records showing no call type are being listed.

 

[grecon]

How do I get rid of it showing blanks since it is now duplicating my data. Is that a linking issue??

 

[kray4660]

Did you click on the Select Distinct Records (Under Database menu item)? If so, then it could be a linking issue.

I hope this helps.

 

[fisheromacse]

how many/what tables are involved? and how are they linked?

if you post the SQL it may help with troubleshooting in this case. (Database menu -> Show SQL Query, then copy/paste it)