RE: Difference of two ratio numbers

Question

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 .

Harshit Bumb (Appyzie) · Answer

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
 )
)

Harshit Bumb (Appyzie) · Answer

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)
 )
)

Harshit Bumb (Appyzie) · Answer

You can add richTextDisplayFields in your gridRowLayout and then add color to it using the same logic.