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

[vishsaggi]

Can you show us the expressions you are using ?

[#3]

Sorry

Inv Qty is [Inventory Free Quantity]+[Inventory Reserved Quantity]

and

The price is [Inv Qty]*[Sales Unit Price]

in the second I get a message saying "Errors in expression"

[ahaahaaha]

Hi,

May be Sum( [Inv Qty]*[Sales Unit Price])

[vishsaggi]

Can you send me the snapshot where its throwing the error? Are Inv qty and Sales unit price fields from a table or labels from other expressions? I need to know where exactly you are using these.

[#6]

Inv Qty is an expression that I have built

[#7]

same issue still says it's an error

[vishsaggi]

Can you share the expression you have for this [Inv Qty]? Hmmm not sure why it is throwing error. BTW what error is that can you take a snapshot of that actual error msg?

[awhitfield]

Hi Dave,

any chance that you could upload an example QVW?

Andy

[#10]

no company policy, not even using the scrambler