Set Analysis - how to set a field based on another

[#1]

Hi , just having some difficulty with setting a field (ResDayNum) based on another field (KeyDateNum).

Hopefully this explains the problem....

[Gysbert_Wassenaar · Accepted solution]

Set analysis calculates a set per chart, not per row. So for what you want you can't use set analysis. You'll have to use an if statement. sum(if(ResDayNum=KeyDateNum,PriceN)).

[#3]

Thanks - interesting to know the row dimensions still applies in set analysis