Nested If function is not returning neither True or False
I am trying to use the ForAll function in Power FX to iterate over a collection called colMatSolicitados. Within the ForAll function, you are using an If function to check if a certain condition is met, and then setting the value of varT based on the result of that condition. The condition you are checking is whether the value of Ambito.CantidadRequerida is less than the result of a calculation that involves the LookUp and Filter functions, as well as the Sum function. Regardless of the calculation, the result shold be 'True' or 'False', but non of them is happening. I appreciate your help!!
The expressions varT = 1 and varT = 2 do not set the value of the variable varT to 1 or 2; they are comparing the value of varT with 1 or 2, and that result is not being used. Notice that ForAll will evaluate the expression for all records of the collection colMatSolicitados, so if you were to set the value of varT to one value for one row it would be overwritten in the next. In addition, the documentation of the ForAll function states that "that records can be processed in any order and, when possible, in parallel" - which is exactly why functions such as Set are forbidden in the expression, as it could lead to unpredictable results.
If you want to find out how many records match your condition, you can do it with the Sum function, with an expression similar to the one below:
Sum(
colMatSolicitados As Ambito;
If(
Value(Ambito.CantidadRequerida) < (LookUp(Filter(...)) - Sum(...));
1;
0
)
)
- Using or in if statement (Python)
- C# Creating a Square
- Return TRUE/FALSE column for checking if a set of columns contains a value/string
- Does Go have "if x in" construct similar to Python?
- Does if (myBool == true) differ computational wise to if(myBool)?
- Write a Basic Car rental program on java / problems
- Writing a "Chessboard" function in Python that prints out requested length of binary
- Will my program execute "else" even if it executed my "if"?
- Why Java does not see that Integers are equal?
- How to have the Xcode 3.1 compiler warn of assignment operator in an if statement?
- Nested if Statement good or bad?
- How to write if statement in .tmux.conf to set different options for different tmux versions?
- is not null Vs != null (Unity C#)
- VBA "does not equal" code not stepping through IF statement as expected
- Avoiding nested if else statement ladder in Python
- I want to take output from a function to use in a IF statement in another function
- What actually happens when we put conditions without [] (brackets) in if else block in a bash script?
- C++ The if statement is still true even when only one condition is met
- Fortran if statement errors
- How can I change certain values in a column based on multiple conditions, leaving others as they are if the conditions aren't met?
- If statements to process a specific numeric value of a variable always fall into the last if statement no matter the value of the variable
- If formula (the sum is less than 30 then roundup tp 30)
- In what conditions is one comparison for "if" and "if-else" at С as at assembly?
- Replace IFs and FOR LOOPs with STREAMs and LAMBDAs
- Symbol equivalent to NEQ, LSS, GTR, etc. in Windows batch files
- if statements matching multiple values
- How do I check if a string contains only numbers and not letters
- How to make a SQL "IF-THEN-ELSE" statement
- Using Javascript inside blade @if
- JavaScript conditional - how to test if a variable matches any of a list of values?