How to calculate average of three values

[mahnoor1279]

I want to calculate the average of these three expressions to show in KPI and also in the table for each customers.

if(isnull(REVIEWED_DATE),TODAY()- ENTER_DATE,REVIEWED_DATE - ENTER_DATE)

+
if(not isnull(ACCT_REJECT_DATE),ACCT_REJECT_DATE - REVIEWED_DATE,Today() - REVIEWED_DATE)

+
IF(Status ='PROCEED',(ACCT_OPEN_DATE - LOG_SHEET_DATE))

[TcnCunha_M]

My suggestion
Move this to script

than you sum everything and split for 3 ?

if prefer to keep this expression:

(

if(isnull(REVIEWED_DATE),TODAY()- ENTER_DATE,REVIEWED_DATE - ENTER_DATE)

+
if(not isnull(ACCT_REJECT_DATE),ACCT_REJECT_DATE - REVIEWED_DATE,Today() - REVIEWED_DATE)

+
IF(Status ='PROCEED',(ACCT_OPEN_DATE - LOG_SHEET_DATE))

)/3