Sum where a field matches a combination of another field and text

[marteeke]

Hi everyone,

I'm trying to sum based on where a field matches a combination of another field with added text.

I've used the code below in a text-object, which shows as 113 (which is the value i want). Vertrekdag is 1.

Vertrekdag&'13'

When i try my sum like this it works;

=Sum({<RouteNr = {'113'})>} AantalBesteld)

However when i combine those two  in the sum below it doesn't work.

=Sum({<RouteNr = {Vertrekdag&'13'})>} AantalBesteld)

It's probably something with formatting but i'm not sure what to search for and haven't found examples close to this.

 Thanks!

[arulsettu]

maybe like this

assuming  Vertrekdag  =1

=Sum({<RouteNr = {'Vertrekdag'})>} AantalBesteld)&'13'

[arulsettu]

can you share sample app to check

[sunny_talwar · Accepted solution]

Try this

=Sum({<RouteNr = {"$(=Vertrekdag&'13')"}>} AantalBesteld)

[marteeke]

Great, this works!

Thanks for the quick reply.
I had been trying things close to that but apparantly i didn't get it right.