Forum Discussion
Issuance and Reciept Inventory from inventory Table
Hi Experts, I have InventTrans Table and in that table there are 2 columns 1 field StatusIssue 2 StatusReceipt. Now if the StatusIssue is == Sold this will show me Issuance and if the field is ...
Hi Prakeet,
output should be
| Issuance / Sold | Reciept / Purchased |
Best Regards,
Shabir Ahmad
Hi shabirAhmad ,
Prateek's solution is perfect based on your 1st explaination. Problem which i see with your explaination is that you have 2 comparative values but you are expecting 3 outputs. can you please explain. there is something that you couldnt put in your question.
if you want an output like this, then prateeks solution is the most appropriate.
if this is not your output table, then please provide table layout you are looking for with the fields filled as we did, fill it the output values as well please.
we all are here to help 😐