Expression Error

[Andy1120]

HI.
I write an expression like this "{IIF(price1==0,IIF(Sum(quantity)==0,Sum(amount),Sum(amount)/Sum(quantity)),price2)}" .
it is get error that Sum is not exists.Why! how can I do ?
Thank you.

[HighAley]

Hello.

Could you specify where do you use this expression.
Please, send us your report template for analysis.

Thank you.

[Andy1120]

Hello
I use it in the column expression ,it is the dispaly value in the data area

[Alex K.]

Hello,

Please try to use the Totals.Sum() function.
If it is does not help, please send us a sample report with test data for analysis.

Thank you.

[Andy1120]

Hello
I use it in the column expression which is in the data area.if the expression is like “{IIF(price1==0,sum(amount)/sum(qty),price2)}” that is correct. if the expression has two IIF and uses the function of Sum that is error.it says the sum is incorerct,How Can I do?
Thank you!

[HighAley]

Hello.

Please, send us a report template with sample data to reproduce the issue.

Thank you.

[Andy1120]

hello
I send a report template to you.you can see it in attachment.I use the exspression in the price column.
Thank you.

[Alex K.]

Hello,

Please simplify your sample report and send us, also please send us a test data for your report.

Thank you.

[Andy1120]

hello
I send a report template and date to you.you can download it in attachment.
Thank you.

[Alex K.]

Hello,

Please try to use the Totals.Sum() function.

Thank you.