Skip to Content
author's profile photo Former Member
Former Member

Problematic Formula

Post Author: PSG-Samuel

CA Forum: Formula

Hello,I have a field in a database that is blank by default and so if its blank by default I want the report to show a Yes | No question, here is the current formula I have: If {tblOSEquip.Custom1} = "" then "Yes | No" else {tblOSEquip.Custom1}But on the report this is showing as blank (and the database field is empty) so it should be showing Yes | No Any ideas?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 31, 2008 at 04:44 PM

    Post Author: amr_foci

    CA Forum: Formula

    try to use

    if isnull({tblOSEquip.Custom1}) then "Yes | No" else {tblOSEquip.Custom1}

    good luck

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 31, 2008 at 05:15 PM

    Post Author: PSG-Samuel

    CA Forum: Formula

    Hello,This gave a blank result and didn't show the Yes | No although the table in the database is empty.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 31, 2008 at 05:24 PM

    Post Author: kcheeb

    CA Forum: Formula

    The table is empty or the columns are empty?

    If the table is empty, you have no rows returned, so nothing to show.

    If the column in the row is null, the formula should work.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 31, 2008 at 05:34 PM

    Post Author: PSG-Samuel

    CA Forum: Formula

    Hello,Sorry its the coloum thats empty....So I have a table called: tblOSEquip and a column called Custom1 which when it has no value is just blank.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 31, 2008 at 05:44 PM

    Post Author: yangster

    CA Forum: Formula

    first thing you could try is if isnull({tblOSEquip.Custom1}) then 1 else 0If you all your results are 1's then they truly are nullsif you get 0's then they are not null and are actually blanks but probably contain some sort of junk blank spaces in them, in that case useif trim({tblOSEquip.Custom1}) = "" then "Yes | No" else {tblOSEquip.Custom1}

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 31, 2008 at 07:21 PM

    Post Author: PSG-Samuel

    CA Forum: Formula

    Hello,Both of these formulas resulted in blank results.I am editing the display string formula, is this correct?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 31, 2008 at 07:26 PM

    Post Author: PSG-Samuel

    CA Forum: Formula

    Hello,Ah I created a new formula field and then used your trim formula and it works a treat.ThanksSAM

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.