Wednesday, November 10, 2021

Combination of some fields in a formula where some fields are null

 If IsNull({X_MONEY_RECEIPTS_REP.ORDER_CODE}) Then

    {X_MONEY_RECEIPTS_REP.IDENTITY}

Else

    {X_MONEY_RECEIPTS_REP.IDENTITY}+" / "+{X_MONEY_RECEIPTS_REP.ORDER_CODE}

No comments:

Post a Comment

 https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/