@anonymous008_G
First Condition: isNull([Row-1:Sector])
What it checks:
It tests whether the field [Row-1:Sector] is null (i.e., missing or undefined) in the previous row.
Result:
If true: The formula returns 1.
This might be used as a starting condition, for example, when processing the first row (where there is no previous row) or when the previous row's Sector is missing.
If false: It moves on to the next condition.
Second Condition: [Row-1:Sector] = 'Hard'
What it checks:
It tests if the previous row's Sector is exactly equal to the text "Hard".
Result:
If true: The formula returns 0.
If false: It continues to the next nested IIF.
Third Condition: [Row-1:Sector] <> 'Hard' and [Row-1:Flag] = 1
What it checks:
Here, two conditions are evaluated:
The previous row's Sector is not equal to "Hard" (i.e., it is something else).
The previous row's Flag is equal to 1.
Result:
If both conditions are true: The formula returns 1.
If not (i.e., either the Sector is "Hard" or the Flag is not 1): The formula returns 0.
