Product Ideas

Share your suggestions and ideas. Vote on ideas you find valuable.

Average new Jf(x) function - NL("Average"; Table ; Field)

Add a new function to the Jf(x) called AVERAGE under the NL family

So you can easily calculate the Average for a given field of a table.

=NL( "Average"; "Cust. Ledger Entry"; "Currency Factor"; "Currency Code"; USD ; "Posting Date" ; "01/01/2017..30/06/2017"

Use case in the real world :

Calculate the average for a currency factor for a given period

Calculate the average for a Unit Price or Unit Cost

Why should we implement this :

In order to calculate an average today customers are forced to perform data dump as a first step,

and then calculate the average as a second step.

 

NL(Average) will then allow Jet Professional to calculate average in a very easy fashion.

  • Tarek Demiati
  • Jul 9 2017
  • Under Consideration
  • Attach files
  • Guest commented
    October 28, 2017 19:47

    Using NL(Sum) functionality, it should be easy to program this new feature.