Math – Determine Ratio

This activity takes two numbers and returns the ratio between those number, as well as the numeric components so you can put them in text. The input is a decimal field but it will accept any numeric field in CRM, including whole number, decimal, float, double and Money.

Example

You have a workflow to email sales effectiveness for the past week. Your workflow already uses “Query – Get a Single Value” to get the number of opportunities won vs total opportunities closed

Input:

  • Value 1 = Result of the number won (12)
  • Value 2 = Result of the number closed (66)

Result:

  • Ratio Value 1 = 1
  • Ratio Value 2 = 5.5
  • Ratio Expression (text) = 1:5.5
  • Ratio Evaluated = True

With this examples, you could take the results and set text such as:

{Ratio Value 1} opportunity Won out of every {Ratio Value 2} opportunities.

Input Parameters

Parameter Name Type Description Default
Value 1 Decimal The value to be evaluated in the ratio
Value 2 Decimal The value to be evaluated in the ratio
Number of Significant Digits Option Set For Ratio Value 2, the number of significant digits to be included. {not specified}
Number of Decimal Places Option Set For Ratio Value 2, the number of decimal places to be included. {not specified}

Output Parameters

Parameter Name Type Description
Ratio Value 1 Decimal The first part of the ratio expression (antecedent). This will be 1 if the values could be evaluated.
Ratio Value 2 Decimal The second part of the ratio expression (consequent).
Ratio Expression Decimal The resulting ratio expressed as “A:B”
Ratio Evaluated Boolean If the numbers provided could be evaluated as a ratio.