Working with Data: All the calculations you need t
  • Introduction
  • What is this book?
  • How to Use this Book
  • Document Notes
  • Authors' Thanks
  • Strings
    • Concatenate
    • Split
    • Length
    • Slice
    • Trim
    • Contains
    • Match
    • Replace
    • Upper/Lower Case
  • Numbers
    • Sum
    • Average
    • Roll Ups
    • Round
    • Floor
    • Power
    • Square Root
    • Absolute
  • Dates
    • Date Difference
    • Age
  • Logical
    • Logical Operators
    • If
    • Case / Switch
    • Is Null/Empty
  • General
    • Count
    • Filter
    • Sort
    • Lookup/Join
    • Variables
    • Convert Type
  • Appendix
    • DateTime Parts
    • Helpful Resources
Powered by GitBook
On this page
  • Excel
  • Tableau
  • Alteryx
  • OrgVue
  • tSQL
  • Python

Was this helpful?

  1. Numbers

Power

Excel

=‹number›^‹power›

=A1^B1
=2^3

Tableau

‹measure›^‹power› OR ‹number›^‹power›

[Absence Instances]^[Duration] 
// OR
2^3

Alteryx

~POW!~(‹measure›, ‹power›) OR ~POW!~(‹number›, ‹power›)

POW([Absence Instances], [Duration])
// OR
POW(2, 3)

OrgVue

~Math.pow!~(‹measure›, ‹power›) OR ~Math.pow!~(‹number›, ‹power›)

Math.pow(node.absenceinstances, node.duration);
// OR 
Math.pow(2,3);

tSQL

‹measure›^‹power›

SELECT AbsenceInstances^Duration AS Bradford
FROM EmployeesData

Python

‹number›**‹power› OR ~math.pow!~(‹number›, ‹power›)

2**3
# OR
import math
math.pow(absenceInstances, duration)

NB.

  • This requires the math library to be imported.

PreviousFloorNextSquare Root

Last updated 5 years ago

Was this helpful?

The above example assumes variables have been declared for absenceInstances and duration. For more information, go to .

General > Variables