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
    Lawrence KS


  • 2.  RE: calculated field Smartlist Builder

    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.

    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 -
    Chapter Leader - Louisiana (New Orleans)

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