Need help with "IF" statement

Follow

Yuriy Gordiyenko

• October 09, 2017 15:14

Hello,

I need help with following formula:

The formula what I'm using is following and it's working [365 * (@Payoff Wire Amount - (@Net Loan Amount - @Remaining Rehab Holdback))/(@Net Loan Amount - @Remaining Rehab Holdback) / @Actual Duration (In Days]

Basically I need to show calculation result only if we have value in Payoff Wire Amount field and if not, keep it empty.

This is the Exel format formula what I'm trying to implement:
If(@Payoff Wire Amount=””,””,365 * (@Payoff Wire Amount - (@Net Loan Amount - @Remaining Rehab Holdback))/(@Net Loan Amount - @Remaining Rehab Holdback) / @Actual Duration (In Days)

Thank you kindly :)

0

• 

  Rainer Grabowski

  • October 09, 2017 16:03

  Hi Yuriy,

  it's simply:

  @Payoff Wire Amount != null ? 365 * (@Payoff Wire Amount - (@Net Loan Amount - @Remaining Rehab Holdback))/(@Net Loan Amount - @Remaining Rehab Holdback) / @Actual Duration (In Days) : ""
  
  Rainer

  0

  Comment actions Permalink
• 

  Yuriy Gordiyenko

  • October 09, 2017 16:10

  Hi Rainer,

  Thank you so much!!!

  0

  Comment actions Permalink

Please sign in to leave a comment.