This video we are going to discuss the NUMBER data type. The Number data type is used to store integers, and real numbers. When you create a column as a NUMBER, you can store pretty huge or pretty small numbers in this column. Now there are two things you need to consider when working with numbers, and that is the precision as well as the how big the number is.
For example, we can store the number 9.9. This has two significant digits. We could also store the number 9.9 X 10^4. In this situation, the number is much larger, but the number of significant digits is the same. 9.9 are the significant digits. When we expand this out we just have 99000, and the zeros are just used for size and are not considered "significant" in this situation. In fact, you get a max precision of 38, but a maximum value of 9.99 * 10^125. You can also use this data type to store very small numbers. Check the docs for the specifics on maximums and minimums.
You can provide it with two pieces of information:
Precision - The total number of digits.
Scale - The number of digits to the right of the decimal.
You do it in this format: NUMBER (precision, scale).
The important thing to remember in this is that when you specify a precision, you will be limiting the max size of the numbers.
The secret behind this data type is that it is actually stored in scientific notation. That is we store a number and then we can multiply it by 10 raised to some power. This allows us to store much larger numbers without taking up a ton of space.
The oracle docs actually gives a formula that you can use to see how much storage is going to be required for a specific NUMBER data type.
How much precision can be used? The acceptable range is 1-38.
What about scale? The range is actually -84 to 127. I'll explain the scale in more detail in an upcoming video. That's because there is a lot of confusing things here…What does it mean for the scale to be negative? How can we have a scale that is bigger that the total number of digits available through the precision. That's a topic for another video.
It's important to understand that when we increase our scale, we decrease the max size of the number. For example if we have a precision of 5 and a scale of 3, the highest number we can store is 99.999. This is in contrast to a precision of 5 and a scale of 2 which allows for up to 99.999. Either way you get 5 significant digits, but the numbers of digits to the left and right of the decimal change.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Support me! http://www.patreon.com/calebcurry
Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter
Donate!: http://bit.ly/DonateCTVM2.
~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~
More content: http://CalebCurry.com
Facebook: http://www.facebook.com/CalebTheVideoMaker
Google+: https://plus.google.com/+CalebTheVideoMaker2
Twitter: http://twitter.com/calebCurry
Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)

Views: 7594
Caleb Curry

Formatting numbers for money and other purposes using NumberFormat
How to Round a Number to 2 Decimal Places in Java:
http://mergetag.com/round-a-number-to-2-decimal-places-in-java/

Views: 1731
Meri Engel

The DECIMAL data type is similar to the INT data type in that when you use the number for math, it maintains precision. The difference though is obvious in the name. The DECIMAL data type allows for numbers after a decimal point (and before the decimal point). The DECIMAL data type allows us to store what is known as a fixed-point number. A fixed point number is a number that has a specific number of digits available to store numbers in. That means we can't do things like use a DECIMAL data type to store as many digits of PI as possible, because we can't store unlimited digits. We are limited to a certain number.
There are two keywords you need to understand when you are working with the DECIMAL data type, precision and scale. Precision is the number of digits and scale is the number of those digits that will come after the radix. You are going to want to provide these numbers when you declare a column of this data type.
For example, DECIMAL(5, 2) has a precision of 5 digits and a scale of 2 digits. That means we can store a maximum of two digits after the decimal and four digits total. This gives us a possible range from -999.99 to 999.99
The highest number of digits is 65, and the highest number of digits after the decimal is 30.
This data type is also known as DEC, NUMERIC, and FIXED.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Support me! http://www.patreon.com/calebcurry
Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter
Donate!: http://bit.ly/DonateCTVM2.
~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~
More content: http://CalebCurry.com
Facebook: http://www.facebook.com/CalebTheVideoMaker
Google+: https://plus.google.com/+CalebTheVideoMaker2
Twitter: http://twitter.com/calebCurry
Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)

Views: 7294
Caleb Curry

In a previous video (https://www.youtube.com/watch?v=o_Qh0SccyAc) I showed you how to write natural language narratives in Power BI.
In this video I will show you how to format decimal numbers inside your natural language text.
Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1
Our PLAYLISTS:
- Join our DAX Fridays! Series: https://goo.gl/FtUWUX
- Power BI dashboards for beginners: https://goo.gl/9YzyDP
- Power BI Tips & Tricks: https://goo.gl/H6kUbP
- Power Bi and Google Analytics: https://goo.gl/ZNsY8l
ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
https://curbal.com/product/sponsor-me
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: https://goo.gl/rvIBDP
► Facebook: https://goo.gl/bME2sB
#POWERBITIPS #CURBAL #POWERBI #MVP
► Linkedin: https://goo.gl/3VW6Ky

Views: 3796
Curbal

Microsoft SQL Server 2005 Implementation and Maintenance

Views: 2537
idahotechy

FLOAT and DOUBLE data types are data types that can be used to store numbers that can include decimal numbers. They are specifically used to store estimates. What do I mean? I mean that the precision of a FLOAT or DOUBLE value can be lost when doing math. The data types are only capable of maintaining a certain level of precision. The level of precision is usually adequate for most mathematical operations. If you need to store exact data, you will want to look into using the INT or DECIMAL data type instead.
The numbers stored in a FLOAT or DOUBLE column are called floating point numbers, we'll see why in just a moment.
Why are they called floating point numbers? let's look at a number. 150. This number could be represented as 150, or it could be represented as 1.5 * 10^2, or 1.5e2. With floating point numbers, scientific notation is used. These numbers are called floating point numbers because the decimal can float to different spots as we change the exponent.
This means that the data type needs to store the number, how many decimal the number needs moved, and a sign bit.
The benefit of floating point numbers is that they allow us to store pretty huge numbers. The down side is that they are not storing values exactly because they are limited in size. This means that only a certain level of precision is to be expected from a floating point data type.
If you remember from the video of DECIMAL, precision is the number of digits in a number. As long as the precision for one of these data types exceeds the need for your specific data, the data type can work fine. For example, if you are storing a number like 15 trillion, you don't have to worry as much with precision as your number does not contain a lot of digits. This number can be represented as 1.5 x 10^13. This is a lot different than trying to store 1.5534534534 x10^13.
Now we know both of these data types do not maintain a high number of digits correctly, but what is the difference between FLOAT and DOUBLE. The difference is the amount of storage they take up. Float takes up 4 bytes while DOUBLE takes up 8. The benefit in DOUBLE is that because it has more room to store data, it has a higher level of precision and can store bigger numbers.
Now, what level of precision can you expect from either of these? FLOAT around 7 and DOUBLE around 15. Now, these data types are obnoxious because the exact values depend on your operating system and in general these monsters cannot be trusted. Especially when you start doing math with different numbers. In general, it is recommended to use the DOUBLE data type to have a higher level of precision and calculations in MySQL are done with DOUBLE.
Always remember… prepare for trouble, make it double.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Support me! http://www.patreon.com/calebcurry
Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter
Donate!: http://bit.ly/DonateCTVM2.
~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~
More content: http://CalebCurry.com
Facebook: http://www.facebook.com/CalebTheVideoMaker
Google+: https://plus.google.com/+CalebTheVideoMaker2
Twitter: http://twitter.com/calebCurry
Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)

Views: 7399
Caleb Curry

In this video we will learn how to get decimal/float output from Integer division in SQL Server.
I am creating this video to answer once of the question that I posted while back for TSQL Interview Question list
"If I run Select 100/11 what output will I get?"
When you divide Integer by an Integer in SQL Server, SQL Server returns Integer output.
As we can see from our above example, SQL Server output is Integer for Integers division. If we want to get float or Decimal output, Either our denominator or Numerator should be float or decimal type.
If we have both denominator or numerator as Integers, we can use convert or cast functions to convert one of them to float/decimal so we can get our results as float/decimal.
There are multiple techniques you can use to convert/cast to integer to float/decimal, here are some examples
SELECT CAST(100 AS FLOAT) /11 AS OutputResult
SELECT 100/CAST(11 AS FLOAT) AS OutputResult
SELECT 100/CAST(11 AS DECIMAL(12,0)) AS OutputResult
SELECT CAST(100 AS DECIMAL(12,0))/11 AS OutputResult
Blog post link with scripts used in the video
http://sqlage.blogspot.com/2015/02/how-to-get-decimail-output-from.html

Views: 11091
TechBrothersIT

How to round numbers in Java.
here the code:
double R=83.13532213;
R=Math.round(R*100.0)/100.0;
System.out.print(" 83.13532213 to 2 digits"+R);

Views: 20093
DeeDoOo toys

This video gives an introduction to UTF-8 and Unicode. It gives a detail description of UTF-8 and how to encode in UTF-8. This is a video presentation of the article "How about Unicode and UTF-8" which was published on www.gamedev.net.
Writing an STL-Style UTF-8 String Class -
http://squaredprogramming.blogspot.com/2013/12/writing-stl-style-utf-8-string-class.html
How about Unicode and UTF-8 - http://www.gamedev.net/page/resources/_/technical/general-programming/how-about-unicode-and-utf-8-r3322
www.squaredprogramming.com

Views: 140086
Squared Programming

How I like to format SQL statements in order to be quickly and easily read and understood.

Views: 1175
Daniel Meyer

Check out my Blog:
http://exceltraining101.blogspot.com
When you want to remove decimal numbers and not be bothered with rounding there are two functions that can do that: INT and TRUNC. This video gives you a quick example on how it's done.
Feel free to provide a comment or share it with a friend! --------------------------------------- #exceltips
#exceltipsandtricks
#exceltutorial
#doughexcel #exceltips
#exceltipsandtricks
#exceltutorial
#doughexcel #exceltips
#exceltipsandtricks
#exceltutorial
#doughexcel #exceltips
#exceltipsandtricks
#exceltutorial
#doughexcel #exceltips
#exceltipsandtricks
#exceltutorial
#doughexcel

Views: 9304
Doug H

https://www.databasestar.com/oracle-months_between/
The Oracle MONTHS_BETWEEN function allows you to find the number of months between two dates. You can enter two dates and the function returns the difference.
This function is often used as part of other calculations. Sometimes you’ll want to know the difference between two dates to perform other functions.
The syntax of the MONTHS_BETWEEN function is:
MONTHS_BETWEEN(date1, date2)
What do these two parameters mean?
The function performs date1 minus date2. So, if date1 is larger, the result is positive. If date2 is larger, then the result is negative.
What data type is returned?
It depends on the values you provide. If the dates are both on the same day of the month (e.g. both on the 10th of the month), then the result is an integer or whole number. If not, then the result will be a decimal value.
For more information on the MONTHS_BETWEEN function, including the code used in this video and examples, read the related article here:
https://www.databasestar.com/oracle-months_between/

Views: 892
Database Star

Session 6:
Datatypes In Oracle
ALPHABET : A-Z , a-z
NUMBER : 0-9 (with precision and scale)
DATE / Temporal : any Date and time (Hours, Minutes, Seconds, Mili-seconds, Timestamp, Timezone etc)
Alphabet + Number = Alphanumeric Data
= String / CHARACTER Datatype Category
Number = Numeric Datatype Category
Date = Date Datatype Category
1. CHARACTER Datatype:
CHAR, VARCHAR, NCHAR:
CHAR is fixed length datatype and VARCHAR is Variable length datatype to store character data. i.e. A-Z , a-z , 0-9 , all keyboard characters etc.
The default size is 1 character and it can store maximum up to 2000 bytes.
Example : EName, EmpID, PassportNo, SSN, etc.
EName CHAR(10) := ‘TOM’; wastage of 7 space after the string
EName VARCHAR(10) := ‘TOM’; Spaces can be Reuse which left after the string
NCHAR additionally handles NLS(National Language Support).
Oracle supports a reliable Unicode datatype through NCHAR , NVARCHAR2 , and NCLOB
VARCHAR2, NVARCHAR2:
These are Variable length datatype.
VARCHAR2 handles alphanumeric character string whereas NVARCHAR2 handles alphanumeric character string with NLS(National Language Support).
The default size is 1 character and it can store maximum up to 4000 bytes.
LONG: Variable length string. (Maximum size: 2 GB - 1)
Only one LONG column is allowed per table.
RAW: Variable length binary string (Maximum size 2000 bytes)
LONG RAW: Variable length binary string (Maximum size 2GB)
2. NUMERIC Datatype:
NUMBER:
It stores Numeric values and performs numeric calculations.
NUMBER, NUMBER(n), NUMBER(p,s)
It stores Numbers up to 38 digits of precision.
SeqNo NUMBER; 1, 123, 12345678
EmpID NUMBER(4); 1, 123, 1234
Sal NUMBER(7,2); 23456.78 , 123.45 — correction in video: Sal NUMBER(a7,2); which is wrong please ignore.
1234567 can be a type of NUMBER, NUMBER(7), NUMBER(7,0)
It can store both integer and floating point numbers
NUMERIC(p,s)
FLOAT: Ex: EmpSal FLOAT; FLOAT(7) Decimal Points allowed
DEC(p,s), DECIMAL(p,s) , REAL, DOUBLE PRECISION
INTEGER: Ex: SSN INTEGER; Decimal Points are not allowed
INT, SMALLINT
3. DATE Datatype:
DATE:
It stores DATE(Date, Month, Year) and Time(Hour, Minute, Second, AM/PM) and performs calculations with such data.
Default DATE format in Oracle is “DD-MON-YY”
Based on "Gregorian calendar" where the date ranges from “JAN 1 4712 BC” to “DEC 31 9999 AD”
doj DATE; “18-MAR-2010 12:30:00 PM”
TIMESTAMP: It can store all parameters as DATE datatype and additionally it can have “Fraction of seconds” and
TIMESTAMP WITH TIMEZONE / TIMESTAMP WITHOUT TIMEZONE.
Range from 0-9 digits, the default size is 6.
4. LOB Datatype:
LOB: “Large Object” data.
It can store pictures, motion pictures, Textfiles etc.
CLOB: “Character Large Object” is used to store structured information like a text file with a specific file format.
BLOB: “Binary Large Object” is used to store Un-structured information like Image, JPEG files, MPEG files etc.
BFILE: “Binary File” is used to store the pointer to a specific file / Just store the location of a file.
Maximum size: (4 GB - 1) * DB_BLOCK_SIZE initialization parameter (8 TB to 128 TB)
Extra Information:
NCLOB : It supports all the character set supported by CLOB and additionally it handles NLS(National Language Support )
Maximum size: (4 GB - 1) * DB_BLOCK_SIZE initialization parameter (8 TB to 128 TB)
ROWID and UROWID(optional size) Datatype: contains fixed length Binary data.
BBBBBBB.RRRR.FFFFF combination of BLOCK-ROW-DATABASE FILE
Physical and Logical ROWID
Upcoming Session:
Session 7:
Populating Data into Tables(INSERT Statement):
Inserting data into all columns of a table
Inserting data into Required columns of a table
Inserting NULL value into a table
Inserting Special Values(USER / SYSDATE) into a table
Supplying data at runtime(using & and &&)
THANK YOU :)

Views: 98
Prabhat Sahu

DURGASOFT is INDIA's No.1 Software Training Center offers
online training on various technologies like JAVA, .NET ,
ANDROID,HADOOP,TESTING TOOLS , ADF, INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP...
courses from Hyderabad & Bangalore -India with Real Time Experts.
Mail us your requirements to [email protected]
so that our Supporting Team will arrange Demo Sessions.
Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696.
http://durgasoft.com
http://durgasoftonlinetraining.com
https://www.facebook.com/durgasoftware
http://durgajobs.com
https://www.facebook.com/durgajobsinfo............

Views: 850
Durga Software Solutions

How to use concatenation operator, to_char, currency symbol, display money

Views: 1202
Gaivota OracleSQL Lessons

https://www.databasestar.com/oracle-remainder-mod/
The Oracle MOD function performs a “modulo division” on the numbers you specify. A modulo division is where a division is performed using two numbers, and the remainder is returned by the function.
For example, the division of 8/5 is 1.6. Using modulo division, 8/5 will work out there is one 5 contained in the 8, with 3 left over. The MOD function would return 3 in this example.
The syntax of the MOD function is:
MOD(numerator, denominator)
The numerator is the number mentioned first in the division, or the one that is on top of the division sign. In a division such as 15/4, this would be the 15.
The denominator is the number mentioned second in the devision, or hte one that is on the bottom of the division sign. In a division such as 15/4, this would be the 4.
The parameters can be any numeric data type, and the return type depends on these parameters. This means MOD can return a whole number or a decimal number.
The calculation for the Oracle MOD function is: numerator - denominator * FLOOR(numerator / denominator).
If the denominator is 0, the function returns the value of the numerator. This is done to prevent “divide by 0” errors.
For more information about the MOD function, including how to return every second row, how it’s different to REMAINDER, and to see the SQL code used in these examples, read the related article here:
https://www.databasestar.com/oracle-remainder-mod/

Views: 912
Database Star

more info
http://howtodomssqlcsharpexcelaccess.blogspot.ca/2018/02/mssql-round-decimal-to-2-decimal-places.html

Views: 462
Vis Dotnet

This tutorial will show you how recognise if a number field needs to be set to 1 decimal place

Views: 13977
BosworthA2ICT

In this video you'll be taught about the DECIMAL, NUMERIC, FLOAT, DOUBLE and REAL Data Types.

Views: 1482
Coding Senpai

Use the type conversion functions to change the type of an argument.
StringToDate
Returns a date from the given string in the given format. You do not have to specify a format string if your string contains a date in the default format yyyy-mm-dd.
Input: string (string) [,format (string)]
Output: result (date)
Examples: If the column mylink.mystring contains the string ″1958--08--18″, then the following function returns the date 1958--08--18.
StringToDate(mylink.mystring)
If the column mylink.mystring contains the string ″18:08:1958″, then the following function returns the date 1958--08--18.
StringToDate(mylink.mystring,"%dd:%mm:%yyyy")

Views: 5606
WingsOfTechnology

In this silent video, you'll learn how to display mark labels with zero decimal places in Tableau.
Read the full article here: Displaying Zero Decimal Places for Mark Labels -- http://kb.tableau.com/articles/howto/displaying-zero-decimal-places-for-mark-labels
____________________________________________________________________
1. On the Marks card, Right-click the field on Label and select Format.
2. In the Default section, click the drop-down arrow next to Numbers.
3. Select Number (Custom).
4. Change the number of decimals to 0.
____________________________________________________________________
Subscribe to the Tableau YouTube channel here: [link: http://www.youtube.com/subscription_center?add_user=tableausoftware]
Free Trial of Tableau: [link: https://www.tableau.com/products/trial ]

Views: 16661
Tableau Software

In the previous video we talked about some of the most popular data types. We are going to discuss them in more detail. The data type we are going to start with is CHAR and NCHAR. I told you of both of these but I never explained the difference. That's because there is some other stuff I need to explain before I can explain the difference. This has to deal with what is known as character sets.
When you have a string, there are only so many characters you are allowed to store in that string. The characters you are allowed to store is determined by what is known as the character set.
A common character set is ASCII. This character set allows you to store English characters, numbers, and some symbols. ASCII started with 127 characters, and then they came out with the ASCII extended, which allows for up to 255 characters. Even with 255 characters though, we are limited in what we can store using one character set. If the computer only allows ASCII, we are going to be limited when working with different languages. Of course it works for some situations, but globalization of software has been a big thing with the development of the interwebs …and the movement towards a new world order (Revelation 13:7).
That means that ASCII is no longer the best character set. It has largely been replaced with a character set known as Unicode. Oracle has a few Unicode character sets that we can use when we work with string data.
When you start studying character sets, I can promise that you will run across the word encoding. Encoding refers to the way that the allowed characters can be stored on the computer. A computer doesn't just store a letter, everything has to be stored in binary. Unicode is the character set, but it has numerous different encodings. Essentially, the computer can store the same characters in multiple different ways, depending on which encoding is used.
The most popular encodings for Unicode are UTF-8 and UTF-16. UTF stands for Unicode Transformation Format. In the next video we will be discussing these in detail and express their differences. Once we got that down, we'll be able to loop back around to data types.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Support me! http://www.patreon.com/calebcurry
Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter
Donate!: http://bit.ly/DonateCTVM2.
~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~
More content: http://CalebCurry.com
Facebook: http://www.facebook.com/CalebTheVideoMaker
Google+: https://plus.google.com/+CalebTheVideoMaker2
Twitter: http://twitter.com/calebCurry
Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)

Views: 5442
Caleb Curry

Numeric data sometimes gets stored in a database as preformatted strings. Extra characters like commas, spaces, and periods can prevent you from using mathematical functions on that data. In today's video we learn how to use SQL Server's TRY_PARSE function to convert these strings into numeric data types.
Subscribe and turn on notifications to never miss a weekly video: https://www.youtube.com/c/bertwagner?sub_confirmation=1
Related blog post with example code:
https://bertwagner.com/2018/09/25/shortchanged-with-international-money-in-sql-server
Great website explaining the shortcomings of floating point data types: https://floating-point-gui.de/
Another great article showing some of the shortcomings of the money datatype in SQL Server: https://www.red-gate.com/hub/product-learning/sql-prompt/avoid-use-money-smallmoney-datatypes
Follow me on Twitter:
https://twitter.com/bertwagner

Views: 175
Bert Wagner

Download File: http://people.highline.edu/mgirvin/excelisfun.htm
See how to use Power BI Desktop to import, clean and transform Sales Tables from Multiple Excel Files and consolidate into a Single Proper Data Set that can be linked in a Relationship to other tables, and then build DAX Calculated Columns & Measures for Gross Profit that can be used in a Dynamic Dashboard with Map, Column Chart, Line Chart, Card and Slicer visualizations. During the whole process we will compare and contrast how the process is similar and different from Excel’s Power Query and Power Pivot DAX.
The steps we will see in this video are:
1. (00:17) Introduction to entire process for Power BI Desktop, including looking at the finished Dashboard
2. (04:50) Import Multiple Excel Files From Folder
3. (05:44) Name Query
4. (06:02) Transform extension column to lowercase
5. (06:34) Filter Files to only include “.xlsx” file extensions
6. (07:05) Remove Columns
7. (07:18) November 2016 Power Query Update Problem
8. (08:05) Add Custom Column with Excel.Workbook Function to extract the Excel Objects from each File.
9. (09:40) Delete Content Column
10. (10:41) Filter to only include Excel Sheet Objects
11. (11:06) Filter to exclude sheets that contain the word “Sheet”
12. (11:40) Remove Columns
13. (11:51) Expand Data and Sheet Name Columns
14. (12:06) Change Field Names
15. (12:22) Change Data Types
16. (14:05) Add Custom Column to calculate Net Revenue Column then round Number.Round function. Then Add Fixed Decimal Data Type.
17. (15:59) Remove columns for Amount and Revenue Discount
18. (16:10) Close and Apply to add to Data Model
19. (17:05) Import Excel Manager Table. Change Data Types to Text. Close and Apply
20. (18:10) Create Relationship between Zip Code Columns
21. (19:03) Create DAX Calculated Column with the IF Function to Categorize Retail Data. Change Data Type.
22. (21:53) Create DAX Measures for: Total Revenue, Total COGS and Gross Profit. Add Currency Number Formatting with No Decimals Showing.
23. (24:28) Create DAX Measures for: Gross Profit Percentage. Add Percentage Number Formatting with Two Decimals Showing.
24. (25:35) Create Map Visualization for Zip Code & Gross Profit Data (Zip Code with relationship to Managers)
25. (26:20) Create Clustered Bar for Manager Names & Gross Profit Data (Zip Code with relationship to Managers)
26. (27:15) Create Clustered Column for Product & Gross Profit Data, with a Line Chart for Gross Profit Percentage
27. (28:19) Create Clustered Column for Payment Method & Gross Profit Data, with a Line Chart for Gross Profit Percentage
28. (28:45) Create Slicer for States.
29. (29:00) Create Card Visualization for Total Revenue, Total COGS, Gross Profit and Gross Profit Percentage.
30. (29:57) Summary
Learn Power BI Desktop Basics. Introduction to Power BI Desktop. Getting Started with Power BI Desktop. Create Impactful Reports With Power BI Desktop. Microsoft Power BI.

Views: 121676
ExcelIsFun

Example that shows how to get numbers after decimal (.)dot
Also how to fix the following error The data types float and int are incompatible in the modulo operator.
More info: http://howtodomssqlcsharpexcelaccess.blogspot.ca/2013/01/how-to-fix-error-data-types-float-and.html
and here
http://howtodomssqlcsharpexcelaccess.blogspot.ca/2013/01/mssql-how-to-get-numbers-after-decimal.html

Views: 1597
Vis Dotnet

Donate!: http://bit.ly/DonateCTVM2. Videos Available for Download - http://www.udemy.com/calebthevideomaker2-database-and-mysql-classes/
Playlist - http://www.youtube.com/watch?v=krx-w9icrkU&list=PL405B31DD586979DE
Manual:
Decimal: http://dev.mysql.com/doc/refman/5.6/en/fixed-point-types.html
floating point: http://dev.mysql.com/doc/refman/5.6/en/floating-point-types.html
Decimal(M, D)
precision is how many digits are in the number, and scale is how many digits after the decimal.
defaults are 65 and 35
decimals are accurate up to about 7 digits.
doubles are accurate up to about 15 digits.
More content: http://CalebCurry.com
Facebook: http://www.facebook.com/CalebTheVideoMaker
Google+: https://plus.google.com/+CalebTheVideoMaker2
Twitter: http://Twitter.com/calebCurry
Subscribe (it's free!): http://bit.ly/PqPyvH
Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)

Views: 4167
Caleb Curry

Today I will show you how to fix the errors that you get when you try to convert a column to a date in Power BI/ Power Query.
Link to Wikipedia: https://en.wikipedia.org/wiki/Date_format_by_country
Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1
Our PLAYLISTS:
- Join our DAX Fridays! Series: https://goo.gl/FtUWUX
- Power BI dashboards for beginners: https://goo.gl/9YzyDP
- Power BI Tips & Tricks: https://goo.gl/H6kUbP
- Power Bi and Google Analytics: https://goo.gl/ZNsY8l
ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
https://curbal.com/product/sponsor-me
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: https://goo.gl/rvIBDP
► Facebook: https://goo.gl/bME2sB
#POWERBITIPS #CURBAL #POWERBI #MVP
► Linkedin: https://goo.gl/3VW6Ky

Views: 6152
Curbal

In this video I take a look at the structure of tables I plan on using for my database and point on the relational links between the tables. I also discuss the primary key of the table as well as using it as a foreign key in a related table. I take a look at a few basic data types for field columns to include:
CHAR = 255 characters
VARCHAR = 255 characters
SMALLINT = -32,768 to 32,767
INT = -2,147,483,648 to 2,147,483,647
DECIMAL = Numbers with a decimal value
Date = In the format DD-MMM-YYYY
This video is part of a series of videos with the purpose of learning the SQL language. For more information visit Lecture Snippets at http://lecturesnippets.com.

Views: 17718
Lecture Snippets

Next up on our MySQL to-do list is to learn about storing dates and times. There are various data types in MySQL for storing dates and times. It seems MySQL and databases likes to break everything up into multiple data types to make things more organized at the consequence of being confusing and annoying.
This video is going to be talking about the DATETIME, DATE, and TIME data types. These are all used to store, you guessed it, dates and times. The one you choose depends on your needs. If you just need dates, choose DATE. If you just need times, choose TIME, if you need both stored together, choose DATETIME.
Now you set a column one of these data types whenever you want every row for this field to have some sort of date, time or both…but how exactly is the data formatted? This requires us to understand some convention. For example, in the USA at least, if you have something like 4:30AM, by convention you know the hour is 4 and the minutes are 30. But this is just an agreed upon convention. MySQL has its own convention…For example 2017-02-02. The first thing is the year, the second is the month, and the third is the day. That is for the DATE. The convention for time is 22:54:30. The first is the hour (military time), the second is the minute, and the third is the seconds. Lastly, there can actually be fractions of seconds…up to microseconds! .123456. To use fractional seconds though you must specify to MySQL the precision of the TIME or DATETIME when you create it, for example DATETIME(6) would allow microsecond precision.
How do you actually give a date to MySQL? By that I mean let's say you have a table with a column of DATETIME(6), and you want to give a value for that column, how do you format it? It's quoted. For example:
'2017-02-02 22:54:30.333333'
MySQL interprets this as a DATETIME.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Support me! http://www.patreon.com/calebcurry
Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter
Donate!: http://bit.ly/DonateCTVM2.
~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~
More content: http://CalebCurry.com
Facebook: http://www.facebook.com/CalebTheVideoMaker
Google+: https://plus.google.com/+CalebTheVideoMaker2
Twitter: http://twitter.com/calebCurry
Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)

Views: 32712
Caleb Curry

This Video Tutorial Will Describe how to set the default value of the column. This command will also work on other versions of database like Oracle 11g Database, Oracle 10g Database, Oracle 9i Database, Oracle 8i Database, Oracle 8 Database and so on.
DEFAULT clause is used to set the value for the table column. DEFAULT clause insert the predefined value into the column if you left it blank while inserting the column.
Full Syntax will be given in this video tutorial about how to use the DEFAULT clause.
Along with live example to demonstrate DEFAULT clause.
All the keywords, format, mandatory clauses etc are described in this video.

Views: 289
Oracle 12c Tutorials for Beginners

Is there an equivalent of MROUNDUP?
How to round up to next increment of 20?
Review of rounding tricks & techniques
ROUND(Number,Digits) and Digits can be negative to round to 10's or 100's
ROUNDUP is great for killing weeds in your driveway, but also to round up to next 1, 10, 100
MROUND will round to nearest 20, but there is not a MROUNDUP
Instead, use CEILING.MATH
The opposite function is FLOOR.MATH to MROUNDDOWN

Views: 1115
MrExcel.com

This video is part of LearnItFirst's SQL Server 2012: A Comprehensive Introduction course. More information on this video and course is available here:
http://www.learnitfirst.com/Course170
In this second of three videos about data types, Scott will discuss the two categories of numeric data types as well as examples of when to use certain data types.
Highlights from this video:
- What are the two categories of numeric data types and when are each used?
- Why is it important to choose the right numeric type?
- What must you be concerned with when storing numbers with decimals?
- The different integer-based numerics
- When is it appropriate to use money and smallmoney data types for currency?
and much more...

Views: 5453
LearnItFirst.com

This video talks about
Cast function in SQL
SQL data conversions
convert data type to another data type
sql convert functions
convert functions in sql
sql cast functions
sql convert datetime to date
sql cast decimal to int
Part of SQL interview questions and answers
sql questions and answers

Views: 227
Training2SQL MSBI

Learn how to format numbers in Excel 2010.

Views: 96
LACTVEDU

Get the full course: https://courses.xelplus.com
Excel has various tools that can help you easily clean up your raw data for further analysis. Apart from using formulas and formatting, there are two useful Excel features that let you easily clean up. One method is text to columns feature and the other to import external data.
The Get External Data tool can be used to import and analyse data from other systems. This tool is also useful for importing data to run your dashboards or do further analysis using pivot tables, etc. Usually you can get data extracts from any system (e.g. “.dat” or “.csv” from Oracle, “.xml” files from SAP, etc.). These can be imported into Excel.
Importing External Data also gives you control over the decimals and thousand separator, especially if you’re dealing with international companies. In the US, the decimal is dot and the comma is a thousand separator and in most European countries it’s the other way round, where the comma is a decimal and the dot a thousand separator. It’s always safest to Import it properly with the Excel Data Import wizard!
After importing press Ctrl + T to create a table out of it. You can create a pivot table off this one, and when you do, even if you add more data to it, the pivot reflects the new data.
Importing Data from the Web / Internet into Excel – creating web queries that refresh automatically:
In Excel you can also import data directly from the web. You basically create a web query which you set to refresh automatically based on your preference.
★ My Online Excel Courses ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Views: 104507
Leila Gharani

This video show a couple of example of the use of the FORMAT function in SQL Server. This function is very useful, but many people do not know exists in TSQL.

Views: 115
Coopman Greg

Connect C# to SQL, search and filter in DataGridView using TextBox, create setup file with sql database in Visual Studio 2015/2017
How to create exe in .net and attachment with database finally
[C# Application] How to create c# application Setup with SQL Server DataBase
How to create a Setup with a Database (C# windows forms)
How to install C# application with database on Client machine [2017]
How to Create Setup Installation File in Visual Studio
How to Publish an Application in C# and Make the Installation Setup
Visual Studio 2015/2017 How to Create Setup Project Install Run and Uninstall a Program
How To Create a Database Deployment Project in 10 minutes

Views: 4022
Fox Learn

This video will provide you the details of each Mathematical Function in SQL Server 2014.
***********************************************************************
Mathematical Functions Part I
https://www.youtube.com/watch?v=EL9JNDURGvg
*************************************************************************
ROUND (Transact-SQL)
Returns a numeric value, rounded to the specified length or precision.
Syntax
ROUND ( numeric_expression , length [ ,function ] )
Arguments
numeric_expression
Is an expression of the exact numeric or approximate numeric data type category, except for the bit data type.
length
Is the precision to which numeric_expression is to be rounded. length must be an expression of type tinyint, smallint, or int. When length is a positive number, numeric_expression is rounded to the number of decimal positions specified by length. When length is a negative number, numeric_expressionis rounded on the left side of the decimal point, as specified by length.
function
Is the type of operation to perform. function must be tinyint, smallint, or int. When function is omitted or has a value of 0 (default), numeric_expressionis rounded. When a value other than 0 is specified, numeric_expression is truncated.
Return Types
Returns the following data types.
Expression result Return type
tinyint int
smallint int
int int
bigint bigint
decimal and numeric category (p, s) decimal(p, s)
money and smallmoney category money
float and real category float
Remarks
ROUND always returns a value. If length is negative and larger than the number of digits before the decimal point, ROUND returns 0.
Example Result
ROUND(748.58, -4) 0
ROUND returns a rounded numeric_expression, regardless of data type, when length is a negative number.
Examples Result
ROUND(748.58, -1) 750.00
ROUND(748.58, -2) 700.00
ROUND(748.58, -3) Results in an arithmetic overflow, because 748.58 defaults to decimal(5,2), which cannot return 1000.00.
To round up to 4 digits, change the data type of the input. For example:
SELECT ROUND(CAST (748.58 AS decimal (6,2)),-3); 1000.00
Examples
A. Using ROUND and rounding approximations
The following example shows rounding and approximations.
SELECT ROUND(123.4545, 2);
GO
SELECT ROUND(123.45, -2);
GO
*******************************************************************************
SQRT (Transact-SQL)
Returns the square root of the specified float value.
Syntax
SQRT ( float_expression )
Arguments
float_expression
Is an expression of type float or of a type that can be implicitly converted to float.
Return Types
float
*******************************************************************************
SQUARE (Transact-SQL)
Returns the square of the specified float value.
Syntax
SQUARE ( float_expression )
Arguments
float_expression
Is an expression of type float or of a type that can be implicitly converted to float.
Return Types
Float

Views: 139
Softtech forum

This video explains what an alphanumeric outline is and how it works, then shows you how to build a strong one.

Views: 4787
Michael Andrews Bashan

DECIMAL(n,m);
n is the total number of digits allowed in this column
m is the max number of digits you can have after the decimal point.
Example:
salary decimal(7,2);

Views: 146
LearningPoint92

This video explains how to format currency in ssrs reports.
Please let me know your thoughts via comments

Views: 3000
dnanetwork

A common problem in the database world is when we persist in putting numeric data into a string datatype...and then expect to sequence the data in numeric fashion.
This quick tip looks at how to handle it, and covers an interesting AskTom question at the same time.
======================================================
Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.

Views: 639
Connor McDonald

Jasper Report:Rupees to Word In Indian Format.
Number to Word Indian Format on Jasper Report
Let me know if anyone needed the jar file msg me

Views: 1696
Sridhar M

Updated Video showing an easier way check out:
https://youtu.be/QzNxFah1jjM
Download Free Excel Cheatsheet at: https://www.computertutoring.co.uk/free-cheatsheets.asp
European currency formats have the decimals in place of the commas and commas in place of the decimals:
European: EUR 3.847.88
UK: £3,847.88
This video shows how to use the substitute function to covert.
More tutorials can be found at https://www.computertutoring.co.uk/

Views: 18036
Computer Tutoring