Discussions

Expand all | Collapse all

Report Formula - If statement for duration (Deposit Date > Posted Date)

  • 1.  Report Formula - If statement for duration (Deposit Date > Posted Date)

    Posted 02-10-2020 12:21
    Trying to calculate the duration (TAT) from a deposit date to when it was posted. Have the formula correct but since I have some posted dates (CB Posted Date) that is before deposit date (As Of), it is showing a large value like it would in excel. The dates are correct. Either need to ignore those dates/postings or make it blank. 

    If([CB Posted Date]=null,null,
    [CB Posted Date]<[As Of],null,
    [CB Posted Date]>[As Of],[CB Posted Date]-[As Of])

    thoughts??


    ------------------------------
    Mark Davis
    ------------------------------


  • 2.  RE: Report Formula - If statement for duration (Deposit Date > Posted Date)

    Posted 02-10-2020 14:27
    Mark,
    I am assuming you have a Formula Duration field.  Give this a try:

    if (  isnull([CB Post]),  null,
    [CB Posted Date]<[As Of], null,
    [CB Posted Date]>[As Of],[CB Posted Date]-[As Of])

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------



  • 3.  RE: Report Formula - If statement for duration (Deposit Date > Posted Date)

    Posted 02-14-2020 16:51
    Sorry about the delay Don. The formula was correct, had some data for the dates that looked right but somehow was not formatted correctly. Once I corrected it, the formula calculated the TAT. Thanks!!

    ------------------------------
    Mark Davis
    ------------------------------