Forum Discussion

colem246's avatar
colem246
Frequent Visitor
8 years ago

Exclude Null Data from Subtraction

Hello,   Im subtracting two columns that both include the date. Some of the cells are empty because no dates are available for the information.. How can I exclude the null information in the measur...
Need Help
Interkoubess's avatar
Interkoubess
Solution Sage
8 years ago

Hi colem246,

 

 

Please try something with an if like this:

 

if(isblank( or('Activity '[First Time]), 'Activity [Activity Date])),blank(), Activity '[First Time])-'Activity [Activity Date])

Let us know if it does not work...

 

Ninter

  • colem246's avatar
    colem246
    Frequent Visitor
    8 years ago

    This is still giving me 12:00am even when the 'Activity '[First Time] is blank.

     

     

    • Interkoubess's avatar
      Interkoubess
      Solution Sage
      8 years ago

      hi colem246,

       

      Please give a sample data with your expected result and then I can try another approach.

       

      Ninter

      • colem246's avatar
        colem246
        Frequent Visitor
        8 years ago

        Here is an example of what it looks like. The last two columns are using the code you gave me. As you can see the columns at the top have missing data and still gives 12:00am in the last two columns. I would rather the last two columns be null.

         

        Thanks