2 Replies Latest reply on Oct 25, 2018 6:18 PM by Phillip Gaertner

    Simple IF NOT ISNULL calculation

    Phillip Gaertner

      Hi,

      I'm sure this a simple error in my calculation but I just cant seem to remove the nulls from appearing with out using Filters.

      In summary, cfname dimension has several values within it, including nulls. Depending on what the value in cfname is I want the value from customvalue.

      However if I use this calc  'IF NOT ISNULL([Cfname])AND [Cfname]= "CBS Section" THEN [Customvalue] END' I end up with two rows on my worksheet one with the correct record and the other null.

      How do I remove the null from appearing?

      Thanks for your help.

      Phil