Table Po Wise Summation

[nuwanhwb87]

Hi all,

I need to get the second table from the First table. The Available data set is the first table. Original Po number increase it's quantity by adding  ' -A' at the end of PO . i need to sum the Original Po wise quantity.

Please help

Thanks

[rubenmarin]

Hi @nuwanhwb87, using subfield you can get the value until the first '-', so try Subfield([Po No],'-',1) to create the field that merges both values.

Maybe you need to use Text(Subfield([Po No],'-',1))