Calculations and aggregations

265 questions in this forum

1. CASE WHEN PROBLEM

   Asked by KAPITYAN, November 14

   0 votes
   3 answers
2. CASE WHEN PROBLEM

   Asked by KAPITYAN, November 14

   0 votes
   0 answers
3. Calculated field for running balance

   Asked by focus54, January 10, 2013

   0 votes
   5 answers
4. Passing an aggregate value on to another datapage

   Asked by JMR21, October 28

   0 votes
   3 answers
5. Counting records submitted today

   Asked by SaraK, November 3

   0 votes
   2 answers
6. Area of a circle

   Asked by imJihyo, October 30

   0 votes
   1 answer
7. Maximum Number of Calculated Fields in a DataPage

   Asked by princezuko, October 25

   0 votes
   7 answers
8. Concatenate fields to get more than 4 decimal places result

   Asked by KAPITYAN, October 10

   0 votes
   1 answer
9. Check if File Field is Blank

   Asked by IamBlossom, March 22

   0 votes
   2 answers
10. Case Statement involving a date/time field an number field

    Asked by KAPITYAN, October 3

    0 votes
    1 answer
11. SQL count calculation issue

    Asked by LynnR, April 9, 2019

    0 votes
    4 answers
12. Convert a datediff to dd:hh:mm

    Asked by KAPITYAN, September 12

    0 votes
    2 answers
13. Can I get Caspio to total results in a column?

    Asked by aubreycohen, January 19, 2010

    0 votes
    4 answers
14. Concatenate fields without leading spaces

    Asked by KAPITYAN, August 29

    0 votes
    3 answers
15. Extra spaces

    Asked by Batchini, July 30

    0 votes
    2 answers
16. SQL contingent on a Select2 field

    Asked by Roderick, June 6

    • calculated field
    • sql
    • select2
    • select
    • cascading field
    • hidden value
    0 votes
    1 answer
17. Use 'contains' in a calculated field

    Asked by DesiLogi, June 19

    • calculated field
    • syntax
    0 votes
    2 answers
18. COUNT or tally Yes / No fields in Totals/Aggregates

    Asked by roattw, January 24

    0 votes
    3 answers
19. Formula to get the percentage contribution of each record

    Asked by astroboy, June 29

    0 votes
    3 answers
20. Task to update a field value in one table with the max value of a field in a subsidiary table

    Asked by vanderLeest, June 23

    • max
    • top1
    • task
    0 votes
    1 answer
21. select count in a report with search filtering

    Asked by sorin14, June 18

    0 votes
    0 answers
22. Remove string value from text string in formula

    Asked by DesiLogi, June 4

    • formula
    • string
    0 votes
    1 answer
23. Comparing Date field to constant to assign value

    Asked by hmsmorgan, May 29

    0 votes
    1 answer
24. How to apply custom formula for sub-groups in aggregation

    Asked by ttanemori, March 15

    • aggregation
    0 votes
    1 answer
25. Using a task to "export" aggregate, unique values

    Asked by Libby, May 8

    0 votes
    1 answer