Show only highest Value on 2 Calculated fields

  • Resolved tosh11formula

    (@tosh11formula)


    2 years, 8 months ago

    Hi,

    I know this is weird question, but I have 2 Calculated field in the form, Is this possible that I hide the lowest value, for example 1,045 is the lowest so that field will hide and will only show the 1,045.00 value?

    Is this possible?

    Thank you.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter tosh11formula

    (@tosh11formula)

    2 years, 8 months ago

    CORRECTION: I will hide this calculated field, but will show the highest value. is this possible?

    Plugin Author codepeople

    (@codepeople)

    2 years, 8 months ago

    Hello @tosh11formula

    Yes, that’s possible. You can use the SHOWFIELD and HIDEFIELD operations in the “Managing Fields Operations” module (https://cff.dwbooster.com/documentation#managing-fields-module).

    Assuming they are the fieldname1 and fieldname2 fields, you can use any of their equations or insert a third calculated field as an auxiliary, and enter the equation:

    
(function(){
  if(fieldname1<fieldname2){
    HIDEFIELD(fieldname1|n);
    SHOWFIELD(fieldname2|n);
  } else {
    HIDEFIELD(fieldname2|n);
    SHOWFIELD(fieldname1|n);
  }
})()

    Best regards.

    Thread Starter tosh11formula

    (@tosh11formula)

    2 years, 8 months ago

    Hi @codepeople ,

    It works Thank you,

    One thing is there a way to have validation, that 500 above value is required before computing the total amount?

    Here’s my equation
    9500*fieldname11/500

    Plugin Author codepeople

    (@codepeople)

    2 years, 8 months ago

    Hello @tosh11formula

    I don’t know what value you want to validate, but if it is for the fieldname11, you can use a conditional operation in your equation:

    IF(fieldname11<500, 'The value must be over 500', 9500*fieldname11/500)

    Best regards.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Show only highest Value on 2 Calculated fields’ is closed to new replies.