Calculations and Aggregations

401 questions in this forum

1. Caspio not a capable replacement for Excel ? Missing INDEX/MATCH, VLOOKUP, ARRAY, SQL SELECT * functions

   Asked by Ulensr, January 19, 2022

   • sql select
   • index
   • match
   • lookup
   • calculated value
   • performance
   0 votes
   7 answers
2. Hiding columns including aggregation rows in Datapage

   Asked by ray985, August 9, 2017

   0 votes
   2 answers
3. Group by and summarize datapage

   Asked by nrlottig, March 16, 2022

   0 votes
   3 answers
4. Calculated Field Details Page change when checkbox is enabled

   Asked by GIOVAN, March 20, 2019

   0 votes
   7 answers
5. Change the calculation based on the using a checkbox

   Asked by JustTrying, February 12, 2022

   0 votes
   2 answers
6. Case with formula

   Asked by KyleMcAfee, February 25, 2022

   0 votes
   5 answers
7. Case with formula

   Asked by KyleMcAfee, February 25, 2022

   0 votes
   3 answers
8. Calculated Field based on Date Range

   Asked by eunha, February 26, 2022

   0 votes
   1 answer
9. Calculated field error message

   Asked by NikkiC, March 15, 2018

   • calculated field
   • error
   0 votes
   2 answers
10. How to get the max value for multiple fields?

    Asked by SunakoChan, February 12, 2022

    0 votes
    1 answer
11. Averages

    Asked by ptauk1, April 17, 2012

    0 votes
    6 answers
12. Referencing data for Calculation

    Asked by AIloser, November 10, 2021

    0 votes
    4 answers
13. How to create a Formula based on another formula

    Asked by Woolf, October 13, 2021

    • formula
    • current date
    • nesting
    0 votes
    5 answers
14. Blank value result

    Asked by Kuroshi, January 31, 2021

    0 votes
    4 answers
15. Concatenate Date and Time Fields

    Asked by Role21, October 23, 2018

    0 votes
    4 answers
16. Get the duration using a Calculated Field

    Asked by astroboy, March 17, 2020

    0 votes
    2 answers
17. Remove vowels from the string

    Asked by Kuroshi, July 25, 2021

    0 votes
    2 answers
18. error Syntax error with using DateDiff in calculated field in table

    Asked by SGProject, October 22, 2016

    • syntax
    • datediff
    • calcultated field
    • table
    • formula
    0 votes
    5 answers
19. Error in formula

    Asked by Kuroshi, November 30, 2019

    0 votes
    4 answers
20. Calculate DataPage text fields

    Asked by gmwvine, May 22, 2013

    0 votes
    3 answers
21. Concatenate In The Calculated Field

    Asked by Elena, June 10, 2014

    0 votes
    6 answers
22. Error in Formula

    Asked by Kuroshi, December 26, 2019

    0 votes
    2 answers
23. Formatting Average in Aggregate Field

    Asked by Woolf, January 13, 2022

    0 votes
    4 answers
24. Concatenate two fields

    Asked by vigreen, January 12, 2022

    0 votes
    1 answer
25. Hide Calculated Fields

    Asked by Role21, December 23, 2018

    0 votes
    5 answers