- Topics: 5
- Replies: 292
- Posts: 297
This line doesn’t return a Boolean result, it returns values grater than zero based on the bar count between pivots. If you apply it to the chart using a Show View you can see what it’s doing:
By wrapping the IF() function around the PIVOT() line, you changed the result to a true Boolean which allowed the rest to work as expected.