Jump to content

peterhanse

Caspio Ninja
  • Content Count

    62
  • Joined

  • Last visited

  • Days Won

    2

peterhanse last won the day on November 26 2016

peterhanse had the most liked content!

About peterhanse

  • Rank
    Advanced Member

Recent Profile Visitors

964 profile views
  1. Good morning , I have a Pivot Table Report . I'm looking for a solution to replace the "13". For the count of all records with kostentest_cat = 1 (that are 13 records). can someone help. CASE WHEN [@field:kostentest_cat] = 1 THEN [@field:kostentest_hoeveelheid]-([@voorraad_ruw]/13) ELSE [@field:kostentest_hoeveelheid] END regards Peter .
  2. Hi xiang, your solution below works well if there is a record in the table or view . if it is empty , he gets stuck on "no records found" . what can we do about it . <script> var column_number = 1; var myTable = document.getElementsByName("cbTable")[0]; var myRows = myTable.getElementsByTagName("tr"); var lastRow = myRows.length - 1; var myCells = myRows[lastRow].getElementsByTagName("td"); var myTotal = parseFloat(myCells[column_number].innerHTML); var paard = "voeg uw paard toe!"; var voegtoe = "upgrade uw acount!"; if(myTotal>0) { document.write("<p>L
  3. i want use a aggregated total in the footer . is that posible for example: <script> var paard = "voeg uw paard toe!"; var voegtoe = "upgrade uw acount!"; if("cbResultSetTotalsData cbResultSetTotalsDataCellNumberDate" >0) { document.write("<p>Link: " + paard.link("http://google.nl") + "</p>") } else { document.write("<p>Link: " + voegtoe.link("http://caspio") + "</p>") } </script>
×
×
  • Create New...