Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))