Jump to content
  • 0

Formula In Tabular Report Loading Slower Than Molasses



Hi there good afternoon,


Can you suggest a javascript alternative to this SQL statement?  


(([@field:AnnualSalary]) - ([@calcfield:3])) / (([@calcfield:5]) - ([@calcfield:3]))



I have this on my tabular report, and it sure loads ever so slowly because of this. It is literally taking 20 seconds for the page to load. 


The calculation is a "range penetration".  It calculates how much someone's Annual Salary exceeds the minimum of the range, by determining how much it has penetrated through the range.  



Field 1 = AnnualSalary

Field 2 = RangeMin ([@calcfield:3]

Field 3 =  RangeMax ([@calcfield:5]


Please help. Thank you so much in advance. 













Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Something like this

function salCalc() {

  var annSal = document.getElementById('EditRecordAnnualSalary').value;
  var calcF3 = document.getElementById('calcField3').value;
  var calcF5 = document.getElementById('calcField5').value;
  var answerEle = document.getElementById('answerElementID');
  var answerVal = (annSal - calcF3)/(calcF5 - calcF3)

  answerEle.innerHTML = answerVal;

Link to comment
Share on other sites

  • 0

Hi Chad,


Your script works for my purpose, thank you a bunch. I made minor tweeks to make it fit exactly for me.


Also, I figured out a workaround using SQL Select and joining 3 tables internally.


My pages with SQL calculations (instad of scripts) now load a lot faster.



Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...