Please wait...

Float columns

Video versionA video overview of string column in wpDataTables

Float columns in wpDataTablesFloat column type and when to use it

“Float” column type should be used when you need to render numeric values with a decimal part. Even non-float content type from the input will be casted as a number, and render with the amount of numbers after the comma that was defined in the “wpDataTables settings page”.

  • Rendering rules: value is casted as a number, and rendered with number of decimal places, that you defined, after the comma.
  • Sorting rules: arithmetical.
  • Applicable filter types: text (will also work), number, number range, selectbox, checkbox.
  • Issues to note: none.

ExampleA sample table using Float columns

Yearly revenue” column in this table is a Float type column.

wdt_ID Company name Sector Yearly revenue Client since
1 Black Turtle Architecture 10,000,000.00 29/05/2011
3 Theodore Consulting Technology 11,000,000.00 17/05/2004
4 White Wing Industries Business Consulting 1,250,000.00 18/05/2006
5 Twinkles Inc. IT 8,000,000.00 01/05/2006
6 The Large Company Construction 7,000,000.00 01/06/2015
7 Non-Standard Production Construction 3,900,000.00 05/06/2007
8 Jailbreak Machinery IT 27,500,000.00 01/06/2001
9 Infinite Scroll Maniacs IT 20,000,000.00 28/05/1996
10 Thebest Construction Agency Construction 90,000,000.00 01/05/1996
11 Allen Planning Architecture 0.00 18/05/2004
wdt_ID Company name Sector Yearly revenue Client since
∑ = 178,650,000.00
Avg = 17,865,000.00
Min = 0.00
Max = 90,000,000.00

Float column settingsHow to configure float columns

The “Float” column type has several interesting features that differ it from other column types.

From version 2.0 and on, you can set “Decimal places” per individual column that represents the number of digits to the right of a decimal point. If you leave this field blank, the column will use the number of decimal places defined on the “wpDataTables settings page.

In addition, there are four calculation features you can enable for the “Float” columns. You can tick these checkboxes to calculate desired functions (Sum, Average, Minimum, Maximum) for all values for a given column. These calculations will be rendered in the table footer as you can see in the example above. See “Calculation functions chapter of this documentation for detailed info.

Never miss new features!

Join 3000+ newsletter subscribers

Never miss notifications about new cool features, promotions, giveaways or freebies - subscribe to our newsletter! We send about one mail per month, and do our best to keep our announcements interesting.

By clicking "subscribe" you consent that the information you provide via this form will be securely processed and stored in compliance with EU privacy laws (GDPR).
This  information will be used to send you newsletters as well as pre-populate any forms, should you want to edit your newsletter preferences.
You can always use this link to unsubscribe from the newsletter. You can see our Privacy Policy here.