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
