image
ChinHin

3

Problem creating a computed column


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



- ChinHin
image

JiaQii

0

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:
A/B



- JiaQii
image

Lili96

0

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.



- Lili96
image

Bjergsen

3

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 !



- Bjergsen
image

OngChenYu

0

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 !



- OngChenYu
image

ruonan

0

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 .



- ruonan
image

Suhaila

0

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 .



- Suhaila
image

156050E

0

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.



- 156050E
image

AlvinYap

0

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.



- AlvinYap
image

HuiLing

1

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.



- HuiLing
Cancel