RE: Difference of two ratio numbers

31 replies
71 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

Brainy

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

Brainy

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

Inspiring

Thanks it really helped.

Sign up

Login with SSO

Login to the community

Login with SSO