Need help with a nested if statement for a Dimension

[#1]

Actually, this is for a straight table, and not sure if it should be a dimension or an expression, but I guess I can figure that out on my own. What I can't figure out, is how to create an if statement to populate a value for in the (Result) column.

The columns I am evaluating are:

Flag

Excess

Allowance

Fees

And the logic I am trying to implement goes like this:

IF Flag = 'x'

     THEN Excess = Allowance

IF Flag = ''

     IF Allowance > Fees THEN Allowance - Fees

     IF Allowance < Fees THEN 0

Many thanks!

[#2 · Accepted solution]

David,

Try this

Excess = if(flag='X',Allowance,if(Allowance > Fees,Allowance-Fees,if(Allowance<Fees,0)))

-Ram

[#3]

Damn... you make it look so easy with so little code...

Many thanks!!