Help with condition in Report summary totals

[Zaily]

hello guys, im trying to put in one text box, which will sum up the qsdok.mnozstvi for substring(qsdok.pracoviste)1,2 lower than 3 (i have pracoviste 1, 2 and 3)
(without substring the pracoviste is like M1, M2, M3)
but i still get error in my code..

{SumIf(qsdok.MNOZSTVI, substring(qsdok.pracoviste)1,2 < 3}

What is right interpretation of my condition?

Or the other solution could be, if I can somehow make one of the group headers with data condition substring(qsdok.pracoviste)1,2 < 3

[Alex K.]

Hello,

Please try to use the following expression:

Code: Select all

{SumIf(qsdok.MNOZSTVI, int.Parse(Substring(qsdok.pracoviste,1,2)) < 3)}

Thank you.

[Zaily]

Thank you so much, this is it!

[Alex K.]

Hello,

We are always glad to help you!

Thank you.