a number equals an Letter

Hello @loppisinorge

I’ll try to describe the process with a hypothetical example.

Assuming you have the equation fieldname1+fieldname2, you can edit it as follows:

(function(){
var result = fieldname1+fieldname2;

if(4.5<=result) return CONCATENATE(result, ' (A)'); 

if(3.5<=result) return CONCATENATE(result, ' (B)'); 
if(2.5<=result) return CONCATENATE(result, ' (C)'); 
if(1.5<=result) return CONCATENATE(result, ' (D)'); 
if(1<=result) return CONCATENATE(result, ' (E)'); 

})()

Best regards.

Hello @loppisinorge

The equation is simple. It calculates the numeric result (var result = fieldname1+fieldname2;), and compare it with the lower number of the intervals (4.5, 3.5, 2.5, 1.5, and 1). For example, if the numeric result is greater than or equal to 4.5, the corresponding letter is “A”. The CONCATENATE operation concatenates its parameters, in this case, the number and the A letter enclosed between parentheses:

if(4.5<=result) return CONCATENATE(result, ' (A)');

If you need a custom coding service to implement your equations, you can contact us directly via the plugin website:

https://cff.dwbooster.com/customization

Best regards.