how to Create calculated column

Question

Hi,

I want to create calculated column. i have text probability field and estimated revenue field. i want to multiple estimated value with probability field. probability field has value like 10, 20, 5 etc.

pls guide how to create calculated column to perform these calculation.

thx

Answer 1

Hello, thanks for reaching out. For simple calculations like the one you described, the Apply Math Operation module should suffice and enables you to apply Arithmetic Operations such as multiply, divide, etc. For more complex calculations, you can write a script to perform data transformation using Execute R Script, Execute Python Script, and Apply SQL Transformation modules. Feel free to review these tutorials on how to use Apply SQL Transformation and create custom scripts. Hope this helps.

Answer 2

Write a PlSQL program is to calculate Area of Rectongle whose length =20 and width =10