Skip to Content
-2

How to get remaider value of division in calculated column in hana

Jan 22 at 10:59 AM

96

avatar image

Hi Experts,

I need a requirement to get remainder value of division in a calculated column.

In a normal we can use MOD( ) function but it wont works in calculated column.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

ANIRUDDHA SHINDE Jan 22 at 01:27 PM
0

If you select Language as SQL Engine instead of Column Engine with following Syntax MOD(A,B) then it should work.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi ANIRUDDHA SHINDE ,

Thanks for your answer...

I found an another answer. i.e., " % " (modulus operator) which can be use in a Column engine itself to get remainder values.

Example: 3 % 2 = 1

0