Hello All,
I can’t figure this out. I’m using the following formula (@OpenClose) in a chart.
Used as is, I get returned the correct data for the first ‘IF’ statement, but no data for the second ‘IF’ statement.
If I swap the order of the ‘IF’ statements, I get the correct data for the first (previously second) ‘IF statement but not the second.
What am I doing wrong?!?!?!?
Thanks for any/all help or advice.
- Tom
I can’t figure this out. I’m using the following formula (@OpenClose) in a chart.
Used as is, I get returned the correct data for the first ‘IF’ statement, but no data for the second ‘IF’ statement.
If I swap the order of the ‘IF’ statements, I get the correct data for the first (previously second) ‘IF statement but not the second.
What am I doing wrong?!?!?!?
Thanks for any/all help or advice.
- Tom
Code:
// @OpenClose
If {Table.String1} = "Text1" AND {Table.Date1} IN YearToDate
Then "Output1" ELSE
IF {Table.String1} = "Text1" AND {Table.String2} = "Text2"
AND {Table.Date2} IN YearToDate
Then "Output2"