Context Error in Webi

[former_member226760]

Hi Team,

i am able to validate below formula however it is throwing CONTEXT error, Am i missing anything?

=(If (Sum([Value]) >0) Then( Sum([Value] ))Else If (Sum([Value])<0) Then (Sum([Value])) Else 0 ) Where ([Test]="EU")

Value is measure and Test is dimension coming from same query. Report based on Free hand SQL.

-Kedar

[former_member198519]

Modify the formula:

=Sum(If (Sum([Value]) >0 and [Test]="EU") Then Sum(Sum([Value])) Else If (Sum([Value])<0 and [Test]="EU") Then Sum(Sum([Value])) Else 0 )