Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ="<div style=""color:"
- & IF( [Rate]<[Buy] ,"red","green")
- & """>"
- & DOLLAR( [Qty]*[Rate] )
- & "</div>"
- & "<div class=""vmSums"" style=""display:none;font-weight:bold;border-top:1px solid black;""></div>"
- & "<img src=""/_layouts/images/blank.gif"" onload=""{"
- & "var TBODY=this;TBODY=this;while(TBODY.tagName!='TBODY'){TBODY=TBODY.parentNode};"
- & "var dataSum='data-vmSum',dataCnt='data-vmCount',total=value="
- & [Qty]*[Rate]
- & ",count=0;"
- & "if(TBODY.getAttribute(dataSum)){"
- & "total=parseFloat(TBODY.getAttribute(dataSum))+value;"
- & "count=~~TBODY.getAttribute(dataCnt)+1}"
- & "TBODY.setAttribute(dataSum,Number(Math.round(total+'e2')+'e-2').toFixed(2));"
- & "TBODY.setAttribute(dataCnt,count);"
- & "window.clearTimeout(window.vmSumFunc);"
- & "window.vmSumFunc=window.setTimeout((function(){"
- & "var lastrownr=~~TBODY.getAttribute(dataCnt),"
- & "last=document.getElementsByClassName('vmSums').item(lastrownr),"
- & "total=parseFloat(TBODY.getAttribute(dataSum)).toFixed(2);"
- & "last.textContent='$'+total;"
- & "last.style.display='block';"
- & "}), 100)"
- & "}"">"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement