Question

RE: Difference of two ratio numbers

Forum|Forum|2 years ago
January 29, 2024
31 replies
0 views

Hi ,

I need some calculation logic in appain that gives difference of ration numbers example shown below in the screenshot.

Can someone help me to write the logic for this on priority?

Here actual and threshold values are user inputs based on those inputs variance col data to be shown .

harshitb6843

You can create rule inputs for ratio1 and ratio2.

a!localVariables(
  local!ratio1: "3:1",
  local!ratio2: "2:1",
  local!ratio1Array: split(local!ratio1, ":"),
  local!ratio2Array: split(local!ratio2, ":"),
  local!lcm: lcm(
    local!ratio1Array[2],
    local!ratio2Array[2]
  ),
  concat(
    (
      local!ratio1Array[1] * (local!lcm / local!ratio1Array[2])
    ) - (
      local!ratio2Array[1] * (local!lcm / local!ratio2Array[2])
    ),
    "/",
    local!lcm
  )
)

harshitb6843

A more refined code for handling when the number is completely divisible.

a!localVariables(
  local!ratio1: "3:4",
  local!ratio2: "5:6",
  local!ratio1Array: split(local!ratio1, ":"),
  local!ratio2Array: split(local!ratio2, ":"),
  local!lcm: lcm(
    local!ratio1Array[2],
    local!ratio2Array[2]
  ),
  local!numerator: (
    local!ratio1Array[1] * (local!lcm / local!ratio1Array[2])
  ) - (
    local!ratio2Array[1] * (local!lcm / local!ratio2Array[2])
  ),
  if(
    mod(local!numerator, local!lcm) = 0,
    local!numerator / local!lcm,
    concat(local!numerator, "/", local!lcm)
  )
)

S

siddagangus0001Author

Thanks it really helped.

Sign up

Login with SSO

Login to the community

Login with SSO