cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
heytherejem Member
Member

Only perform column calculation if dependant column is not blank

I know this one sounds simple but my formula will not work with a =CALCULATE() argument so i'm struggling with a filter or ISBLANK.

 

My formula which works fine is 

Overall Policy Term (years/months) = (TODAY()-[Original Policy Start Date].[Date])/365
 
which is calculating a decimal value. However, if [Original Policy Start Date] is blank, the value is over 100. I want the calculation to only perform if [Original Policy Start Date] is not blank, else I want the cell to remain empty.
1 ACCEPTED SOLUTION

Accepted Solutions
d_gosbell Senior Member
Senior Member

Re: Only perform column calculation if dependant column is not blank

Couldn't you just do the following:

 

Overall Policy Term (years/months) = IF( NOT( ISBLANK( [Original Policy Start Date] )), (TODAY()-[Original Policy Start Date].[Date])/365 )

2 REPLIES 2
AkhilAshok Established Member
Established Member

Re: Only perform column calculation if dependant column is not blank

Maybe a simple if statmeent in the calculated column:

Overall Policy Term (years/months) =
IF (
NOT ( ISBLANK ( Table[Original Policy Start Date] ) ),
( TODAY () - Table[Original Policy Start Date] ) / 365
)
d_gosbell Senior Member
Senior Member

Re: Only perform column calculation if dependant column is not blank

Couldn't you just do the following:

 

Overall Policy Term (years/months) = IF( NOT( ISBLANK( [Original Policy Start Date] )), (TODAY()-[Original Policy Start Date].[Date])/365 )