cancel
Showing results for
Search instead for
Did you mean:
Highlighted
heytherejem 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

## 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

## 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

## 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 )