1 of 1 people found this helpful
the issue is that sum() is an aggregate so every variable in the formula needs to be aggregated - in the first cclause you need to aggregate lifecycle and CO Status with Min(), MAX or Attr
IF attr( [Lifecycle] )= "Core"
OR attr([CO Status] )= "CO"
THEN SUM([Fixed IT])+SUM([Fixed TW DC OH])+[STD Sales]+SUM([Current Store OH])
ELSE SUM([Fixed Buy])
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
That was it! I figured it was something simple that I was missing. Thank you so much!