Hey guys i want create a measure by using computed column which involves taking a value dividing another value any idea how do i write it out using advance expression? T.T
To ensure that you can divide one value by another value, first you have to check if both attribute is of the same data type which numeric in order to perform mathematics function.
Next, let's say exmaple:
A = 50 B = 5
Then is will be written as:
Just like how you write a minus is '-'
so for a division it will be '/' eg. t1.tablecolumnx /t1.tablecolunmx
make sure that they have similar data types.
You can actually complete it simply by using the division operation . Addition + Subtraction - Multiplication * Division /
It is very simple to use the division operator . This is an example .
Column A divide by Column B is just A/B , thats all . You can then specify the format if you want to change it to your preference .
Please keep it mind that you must choose the same data type , for instance , you cant divide a string . Also make sure you specify the right column !
It is very easy , just see which math operator you need and just apply !
Example you want to divide in your case , Just take value A/value B that's all . Just make sure you choose the right column !
A few things to look out first , ensure that the two columns you are using can be divided , eg : You cannot divide a Column A ( String) By Column B ( Time )
Next , just use the correct mathematical operator . Where in your case would be something like ColumnA/Column B , that's all .
It is very easy to do , you just take Column A divided by Column B
So it is just A/B . That's all . Check that your value and format everything is correct .
Problem creating a computed column
-Check to see which math operator you need it and apply it.
-Make sure that they have the same data types.
First of all, check which math operator you require and apply it.
You asked how to take a value and dividing it with another value. Well that's simple.
All you got to do is e.g: Column A divide by Column B is just A/B . Simple as ABC. However, do make sure that the values can be divided.
For your case, since you need to use a value to divide another, you would only need to use the mathematical operator which for divide is '/'. For example, if you need to take the value from column A and divide it by value from column B, it will be columnA/columnB.