Customize formula depending of the value of a field

Hello,
Thank you for your question.
 

• In order to implement the described logic, the formula has to be specified similar to the following formula:

  "if( ('med_eta') == 1, percent('may_pay'), )"

• In case the dates should not be divided into three separate subfields, the date string data type has to be used. More information about types can be found following the links:
  • Data types in JSON
  • Data types in CSV
• The caption of the null values can be changed both through UI and using the nullValue property of the format object.
  • Using the UI: hover the “Format” button placed on the Toolbar and choose the “Format cells” button in the drop-down list. Change the “Null value” field in the desired way and apply changes.
  • Information about how to change the caption of the null values can be found following the link: Format Object.
• The configuration specified in the report object will be applied both for the classic and flat forms. In case the functionality you desire to implement is different, we would like to kindly ask you to provide more details about the result you want to achieve.
• The full list of operators can be found below:
  • + – arithmetic addition operator. Syntax: a + b
  • - – arithmetic subtraction operator. Syntax: a - b
  • * – arithmetic multiplication operator. Syntax: a * b
  • / – arithmetic division operator. Syntax: a / b
  • ^ – arithmetic power operator. Syntax: a^2
  • < – comparison less than operator. Syntax: a < b
  • <= – comparison less than or equal operator. Syntax: a <= b
  • > – comparison greater than operator. Syntax: a > b
  • >= – comparison greater than or equal operator. Syntax: a >= b
  • == – comparison equal operator. Syntax: a == b
  • != – comparison not equal operator. Syntax: a != b
  • or – logical OR operator. Syntax: a or b
  • and – logical AND operator. Syntax: a and b
  • if – conditional operator. Syntax: if(condition, then, else)
  • abs – function that returns the absolute value of a number. Syntax: abs(number)
  • min – function that returns the minimum value. Syntax: min(number1, number2)
  • max – function that returns the maximum value. Syntax: max(number1, number2)
  • isNaN – function that checks whether the value is not a number. Syntax: isNaN(value)
  • !isNaN – function that checks whether the value is a number. Syntax: !isNaN(value)

We hope it helps.
 
Regards,
WebDataRocks Team

Hello,
 
Thank you for your question on email.
 
Our team did not manage to reproduce the described issue on our side.
 
Please note that the input values of dates have to be compliant with ISO 8601 – The International Standard for the representation of dates and time. For example, “2018-01-10” (date) or “2018-01-10T08:14:00” (date and time).
 
You are welcome to see the CodePen we have prepared trying to reproduce the problem.
 
In case that does not help, we suggest modifying the provided CodePen in the way the problem is reproducible.
 
By the way, we would like to kindly ask you to send messages on the forum so we can handle them quickly.
 
Best regards,
WebDataRocks Team