Page 1 of 2
Expression Error
Posted: Wed Oct 29, 2014 3:21 am
by 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.
Re: Expression Error
Posted: Wed Oct 29, 2014 7:49 am
by HighAley
Hello.
Could you specify where do you use this expression.
Please, send us your report template for analysis.
Thank you.
Re: Expression Error
Posted: Thu Oct 30, 2014 7:59 am
by Andy1120
Hello
I use it in the column expression ,it is the dispaly value in the data area
Re: Expression Error
Posted: Thu Oct 30, 2014 1:27 pm
by 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.
Re: Expression Error
Posted: Mon Nov 10, 2014 3:00 am
by 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!
Re: Expression Error
Posted: Mon Nov 10, 2014 10:41 am
by HighAley
Hello.
Please, send us a report template with sample data to reproduce the issue.
Thank you.
Re: Expression Error
Posted: Wed Nov 12, 2014 3:00 am
by 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.
Re: Expression Error
Posted: Wed Nov 12, 2014 12:30 pm
by Alex K.
Hello,
Please simplify your sample report and send us, also please send us a test data for your report.
Thank you.
Re: Expression Error
Posted: Thu Nov 13, 2014 6:49 am
by Andy1120
hello
I send a report template and date to you.you can download it in attachment.
Thank you.
Re: Expression Error
Posted: Fri Nov 14, 2014 1:23 pm
by Alex K.
Hello,
Please try to use the Totals.Sum() function.
Thank you.