Substring Formula

[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)}

[Alex K.]

Hello,

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

Thank you.

[Abbas]

Hello
I used it but didnt work.....

[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.