Sage 100

 View Only

  • 1.  I am trying to write a formula in a calculated fie

    Posted 08-31-2017 08:17
    I am trying to write a formula in a calculated field in Sage 100 Business Insights Explorer. If I were to write it in excel, I would write =if(AR_InvoiceHistoryDetail.ExtensionAmt=0,0,AR_InvoiceHistoryDetail.ExtensionAmt). I am trying to avoid a division by Zero error. Anybody have any idea how to write this in explorer


  • 2.  RE: I am trying to write a formula in a calculated fie

    Posted 08-31-2017 09:01
    I don't think this can be done. The issue is that there are no ""if"" functions other than IFNULL.


  • 3.  RE: I am trying to write a formula in a calculated fie

    Posted 08-31-2017 12:47
    Agree with Kerry. Looked through all of the functions, yet don't see a test like ""If"", even when trying to break into 2 parts.


  • 4.  RE: I am trying to write a formula in a calculated fie

    Posted 09-01-2017 02:47
    A couple years ago I contacted Sage regarding BIE conditional expressions, and was told it wasn't possible (after speaking with several techs). BIE was never expanded to be useful enough.


Related Content