IF(${size_FY_2024}<=1000,“5”,MIN((${size_FY_2024}/1000)-1+5,“15”))
Could you confirm what your question is about this conditional? Thanks.
2 Likes
@devakumar , if you are using the if-statement try using the if instead of IF. This post discussed previously should also help you explain more on this:
You could use the if() statement when you have to assign a certain value/expression for a certain condition else use another value/expression. Thus, the if statements require three arguments: a condition; the result if the condition is true; and the result if the condition is false.
The syntax would be as follows:
if(condtion,value,value)
if(condtion,expression,expression)
if(condtion,value,expression)
if(condtion,expression,value)
You could learn more about the if-statement by following o…
