Error in Expression: if takes 2-3 parameters

[#1]

Hi,

I have a straight table with a number of dimensions, one is calculated dimension to only include items that start with F.

I have added an expression to calculate the quantity this is a simple addition of 2 fields. When I refresh the presentation I don't have a problem.

However, I need to create another expression work out the invoice amount which is [Inv Qty]*[Sales Unit Price]. The expression editor says that there is an error in the expression and when the reports runs I get the error" Error in Expression: if takes 2-3 parameters. Even though it is not an if statement.

Any help would be appreciated as this is driving me made

[#2]

INV QTY is  [Inventory Free Quantity]+[Inventory Reserved Quantity]

[awhitfield]

So what the syntax being used in this bit: one is calculated dimension to only include items that start with F.

Andy

[vishsaggi]

Are those the fields from the table or some other expression labels. May be try like:

= RangeSum(Sum([Inventory Free Quantity]), Sum([Inventory Reserved Quantity]))

Label this as [INV QTY]

= [INV QTY] * Sum([Sales Price Unit])

Something like this?

[#5]

=if([Item Code] like('f*'),[Item Code]) 

[#6]

[Inventory Free Quantity], [Inventory Reserved Quantity] and [Sales Unit Price] are all from tables

[vishsaggi]

You still getting the same error?

[zebhashmi]

Try this

=([Inventory Free Quantity]+[Inventory Reserved Quantity])*[Sales Unit Price]

[#9]

This doesn't bring an error back in the expression but get the same Error in Expression: if takes 2-3 parameters

[vishsaggi]

There is an if statement somewhere it is picking up. do you have any other statements other than this expression in that? can you check scrolling down or up? I mean maximize your edit script expression and see if there are any other expressions hidden? Else can you send us the snapshots of those two expressions.

[#11]

still doesn't like the expression Inv Qty