Forum Discussion

bdehning's avatar
bdehning
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Custom Column Formula Help

I have the following formula for a custom column.     It works except when Time Started or Time Injured is null and then my column returns an error   if([Time Started]>[Time Injured]) then [Time ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    bdehning 

    pls try this

    if [Time Started] is null or [Time Injured] is null then null else if [Time Started]>[Time Injured] then [Time Injured]-[Time Started]+1 else [Time Injured]-[Time Started]

     

bdehning's avatar
bdehning
Icon for Post Prodigy rankPost Prodigy
2 years ago

 I know that would be best but my report is so big and complicated, its hard to split out just the page and table I need for a sample.   

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

bdehning 

not sure if this is what you want. We can't get text and number in one column

Column = if(ISBLANK('Table (2)'[Time Started]) || isblank('Table (2)'[Time Injured]),999,if('Table (2)'[Time Started]>'Table (2)'[Time Injured],'Table (2)'[Time Injured]-'Table (2)'[Time Started]+1,'Table (2)'[Time Injured]-'Table (2)'[Time Started]))

 

so i used 999 to replace the unknown