Best Way To Using Nested If Concept In SAP HANA
Q: What is a nested “if” statement? A: A nested “if” statement is the true condition in a series of conditions in computer programming. It is used when multiple responses are possible and the outcome for each response is different. As Per My Knowledge Answers is: A: IF with in the IF is called “ Nested IF “. Syntax : if(condition,doiftrue,doiffalse) Nested If Syntax : if(condition,doiftrue, if(condition,doiftrue,doiffalse)) IF with in the IF . In the example shown, we are using nested IF functions to assign grades based on a score. The logic for assigning a grade goes like this: Score Grade 0-63 F 64-72 D 73-84 C 85-94 B 95-100 A To build up a nested IF formula that reflects this logic, we can start by testing to see if the score is below 64. If TRUE, we return ...