Page 1 of 1

Substring Formula

Posted: Sat Apr 30, 2016 1:33 pm
by Abbas
Hello...
I use this function but Something is wrong....stimulsoft says "Sum is not in current context"....

Code: Select all

{Substring("000000000"+((Sum(GetShowReport.قراردادي)-Sum(IIF(GetShowReport.FoodName =="ورودي مهمان",GetShowReport.قراردادي, 0)) )-
(Sum(GetShowReport.يارانه_اي)-Sum(IIF(GetShowReport.FoodName =="ورودي مهمان",GetShowReport.يارانه_اي, 0)) )).ToString(),(int.Parse(Length((Sum(GetShowReport.قراردادي)-Sum(IIF(GetShowReport.FoodName =="ورودي مهمان",GetShowReport.قراردادي, 0)) )-
(Sum(GetShowReport.يارانه_اي)-Sum(IIF(GetShowReport.FoodName =="ورودي مهمان",GetShowReport.يارانه_اي, 0))) ).ToString())),9)}

Re: Substring Formula

Posted: Mon May 02, 2016 6:03 am
by Alex K.
Hello,

Please try to use the Totals.Sum() function in this case.

Thank you.

Re: Substring Formula

Posted: Sun May 08, 2016 7:06 am
by Abbas
Hello
I used it but didnt work.....

Re: Substring Formula

Posted: Mon May 09, 2016 5:28 am
by Andrew
Hello,

Please send us a report template with this formula to support@stimulsoft.com. Please refer to this email in the message.

Thank you.