Open Forum

Expand all | Collapse all

calculated field Smartlist Builder

  • 1.  calculated field Smartlist Builder

    Posted Mar 14, 2019 04:43 PM
    I am trying to create a calculated field for a sales line item report.  I already have one calculated field (Actual Unit Price), but from what I can tell, I can't use that field in another calculated field.  The goal is to get the % difference between the Inv Unit Price and the Actual Unit Price.  I did not use the Round in GP.  I have attached a spreadsheet and the formula in my calculated field.  Any help would be appreciated.


    ------------------------------
    Diane Cooper
    Sr. Accounting Specialist
    PROSOCO
    Lawrence KS
    ------------------------------

    Attachment(s)



  • 2.  RE: calculated field Smartlist Builder

    TOP CONTRIBUTOR
    Posted Mar 15, 2019 11:26 PM
    Hi Diane, you're correct that you can really just call a calculated field that you have setup & then use it in another calculated field. However...
    If your first calculated field is working... Just rebuild the logic again in parentheses in your second calculated field.

    Ex.)
    Actual Unit Price = Qty * Price
    % Difference = Inventory Price ( Qty * Price)

    If I'm off base on what you're trying to accomplish, let me know, but I am fairly certain this answers at least some of your Qs.

    ------------------------------
    Kyle Malone, CPA
    GP Admin - CGB Enterprises, Inc.
    Lead Consultant/Blogger - http://ALaCarteGP.com
    Chapter Leader - Louisiana (New Orleans)
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role