x Want to participate? Join the group to interact
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 4 replies
  • Subscribers 76 subscribers
  • Views 956 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
32
replies
General Discussion
6k
topics
18k
replies
Michele Gaw

Calculations with derived fields – is this possible?

SOLVED
Posted By

I used a derived field on a screen (I used the derived field for a calculation).  When the screen is called, I get a message saying the field cannot be found along with a Safe Call Exception.  I am hoping that I just fudged something up along the way and that this is still possible??

I created the derived field using the Derived Field Wizard.  However, I did notice that a previous post regarding “How to add a Derived Field to Meta Data” can no longer be found.  Therefore, I am wondering if it is still possible to use a derived field and is it possible to add that derived field to a screen?

Any assistance is greatly appreciated!

  • +1
    verified answer

    Happy to discover that derived fields do work.  This turned out to be my error.  When I added the derived field, I created a new view and I failed to update my "FindRecord" script with the new view.  

    I was adding a panel to the screen with a dummy field and I included the name of a view in my FindRecord line (vCompanyCredit).

    In order to get some calculations to work, I had used the original view (vCompanyCredit) in the "from" clause of a new view.  The new view contained my calculated (and derived) field.  So instead of using vCompanyCredit, I was using vCompanyCreditCalc.  I used vCompanyCreditCalc to add the fields to the screen.  However, the panel was still using a record drawn from vCompanyCredit (I forgot to update it :-( ).  That view did not contain my derived field and that is what the error message was telling me.  I changed the view that the panel is using and the error message is resolved. :-)

    Thank you to anyone that reviewed my post! :-)

  • 0 in reply to Michele Gaw

    Thanks for circling back and sharing what helped you Slight smile

  • 0 in reply to Erzsi_I

    Stuck out tongue winking eye  I always try to post the resolution if I can..even if it is just my error.  Lol!

  • 0 in reply to Michele Gaw

    The article "How to add a Derived Field to Meta Data" probably was deprecated before the move to Sage City.  

*Community Hub is the new name for Sage City