>

Formula to work out the difference when value change from Change Log

Refer to Product Ideas
Anitha Khairnar
Edited
  • Account name : NZICC
  • Region: APAC
  • Client version (Enterprise) : 26.1
  • Description of the issue
    • What does the client want to do? Why do they want to do this?
      • Login > Main menu > Change Tracking > Load the columns > Change Type, To Value, From Value, Unit Charge, Unit Change Difference .
      • Customer has added ‘Unit Change Difference ’ custom field with the below formula:
      • Unit Change Difference = If ( {Change Type} = "Units Changed", ({To Value}-{From Value})*{Unit Charge}, -(({To Value}-{From Value})*{Unit Charge}) )
  • What you've already tried or suggested. Why does this not work?
    • Tried making changes to the parameters in the formula, it does not seem to return any value even though all parameters are numeric as well.
    • Validated the formula as correct
  • Business impact if not resolved: Normal
  • Attach relevant files (such as screenshots)
  • Links to articles where you've looked for solutions and also other steps you've taken to research the issue.
  • https://supportcenter.ungerboeck.com/hc/en-us/articles/33094621769495-Configure-Change-Tracking
  • https://supportwebap.ungerboeck.com/NZICC_Prod_0616063482_USI_V30/app85.cshtml#/
  • usiadmin/ITRocks2014

  • Please validate the formula as it is returning blank value 

     

  •  

Comments

8 comments

Date Votes
  • Anitha Khairnar

    Nicole Loh Satya Ram Nukala Please advice

  • Satya Ram Nukala

    Anitha Khairnar Can we send this to dev, this is a bug ! I have used the same formula in Excel it is pulling the values, whereas it is not working in our environment.! Tested QE with the same issue

    Seth Halvaksz FYI

  • Seth Halvaksz

    Anitha Khairnar Satya Ram Nukala I don't know if change tracking supports custom formulas.

    What is the goal of this formula? How will they use this information?

    CC Vernica Lodha 

  • Vernica Lodha

    thats right, we only track standard fields as a part of change tracking.

  • Himanshu

    Seth Halvaksz  - The goal of the formula here is to identify the difference between “To value” and from value" ie., how many units were changed rather than calculating manually. This will help users to identify the difference between values quickly for operational planning and updates.

    When i did looked into the database, i suspect the fields we have to report on are computed fields, so these fields are not text or numeric where excel formula would work (but would work in excel because it would convert those cells into numeric. Would you suspect this be an enhancement in this case?

  • Vernica Lodha

    Great analysis and reasoning, Himanshu . That is accurate - for us to track UDF - whether its a calculation or otherwise, would be an enhancement request. The fact that this is computation of non-numeric formats, would only make it more complex is my naive guess. You can ask the user to submit an enhancement request and we will see if its gets more customer votes to warrant a solution, else the customer will have to do the workarounds they do (excel, manual compute), in order to get this information.

    Hope that helps. Thanks!

  • Seth Halvaksz

    Himanshu thanks for confirming. This sounds like a valuable enhancement.

    Anitha Khairnar Satya Ram Nukala please post a link to the enhancement request for reference.

  • Anitha Khairnar

    Created a request - https://app.pendo.io/s/6229449325477888/listen/feedback/views/ZWNAnL_3nsJ6p5EtfWhAOeEO8vg/items?openItem=uCCLrhFftYz5Y6z8afT9UzNrO1U

Please sign in to leave a comment.

Didn't find what you were looking for?

New post