If statement?!?

[#1]

I've my data like following

Cust ID	Category	Value
1	30
2	35	75
3	99
4	30	250
5	35

I need help with the statement.

In my report I want to present the following.

If category = 30  then present Value as 150 000

If category is <>30 then present Value as 0

If value has a number then present that number times 1000 (x1000). This last one shall overrule the previous statements.

I'm not sure if it's best to do it in the loadscript and load it into colum "newValue" or if I should to it in the expression.

[MarcoWedel]

Alt(Value*1000, -150000*(Category=30))

[Anonymous]

Hi,

You'd better calculate a field NewValue in the script.

Use the following script:

If(Isnull(Value)=-1,

If(Category=30, 150000,0),

1000*Value) as NewValue

Otherwise if you want to use it in a graph directly, just use the following as the expression with Value and Category as dimension:

If(Isnull(Value)=-1,

If(Category=30, 150000,0),

1000*Value)

[#4 · Accepted solution]

I solved it by using

=If(Value>0, sum(Value*1000),(If(Category=30, 150000, 0)))