Calculations and aggregations

145 questions in this forum

1. Convert Scientific Notation to Numeric

   Asked by directrix, March 14

   0 votes
   5 answers
2. Only showing result once

   Asked by NikkiC, March 23

   • calculated field
   • tabular report
   0 votes
   5 answers
3. Accepted SQL commands? Endless calculated field syntax errors

   Asked by roattw, April 3

   0 votes
   2 answers
4. Adding Business Days to a Date Field

   Asked by JeremyMenefee, December 9, 2017

   • date formula
   0 votes
   2 answers
5. Membership fee

   Asked by TakolinJan, March 21

   0 votes
   2 answers
6. SQL use EXISTS to display Yes

   Asked by Tanager, March 22

   • sql
   • exists
   • childtable
   0 votes
   3 answers
7. Calculated field error message

   Asked by NikkiC, March 15

   • calculated field
   • error
   0 votes
   1 answer
8. Add Date to String in Formula

   Asked by DesiLogi, December 20, 2017

   • date convert
   0 votes
   3 answers
9. Calculate Week Number in Formula Field

   Asked by NeoInJS, May 17, 2017

   • formula field; week number
   1 vote
   2 answers
10. Aggregates in table report

    Asked by pgjacob, March 18

    • aggregate
    0 votes
    1 answer
11. Calculation From Aggregation

    Asked by nhunsaker, November 14, 2015

    0 votes
    3 answers
12. Finding second lowest number using SQL

    Asked by pgjacob, March 6

    • sql select
    0 votes
    1 answer
13. Date Format

    Asked by Corey, February 19

    • date
    0 votes
    2 answers
14. DATEDIFF: calculate Years, months and days at same time

    Asked by roattw, February 12

    • datediff
    0 votes
    4 answers
15. Tabular Report Aggregates Case Statement

    Asked by Blledzgreen, January 31

    0 votes
    1 answer
16. Total Hours Worked / Datediff

    Asked by ronbrumbarger, January 21

    • datediff
    • aggregate
    • timesheet
    0 votes
    11 answers
17. calculated fields and aggregate totals- grouping

    Asked by checksum, March 8, 2013

    0 votes
    1 answer
18. count calculation in pivot table

    Asked by peterhanse, October 25, 2016

    • calculation
    • pivot table
    • count
    0 votes
    1 answer
19. Trigger Action Insert Select Distinct: Multiple Values

    Asked by vanderLeest, December 14, 2017

    • trigger action insert select distinct: multiple values
    • trigger action
    • insert
    • select distinct
    0 votes
    4 answers
20. How to tally ye/no responses.

    Asked by nuimage, November 2, 2017

    0 votes
    6 answers
21. Formula field to count text entries

    Asked by tyinawyn, November 15, 2017

    0 votes
    1 answer
22. Checkbox approval in Tab report

    Asked by Corpcat, November 21, 2017

    • tabular report
    • checkbox
    0 votes
    1 answer
23. Calculate on report details page

    Asked by mdav20, September 13, 2017

    0 votes
    2 answers
24. Sum of hrs using a virtual field?

    Asked by mdav20, September 8, 2017

    0 votes
    1 answer
25. Date Calculation in a submission form

    Asked by NeoInJS, February 15, 2017

    • date
    • calculated fields
    • script
    0 votes
    3 answers