Issuance and Reciept Inventory from inventory Table

[shabirAhmad]

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 StatusReceipt is == Purchased it will be Reciept now how can i get this.

Best Regards,

Shabir Ahmad

[shabirAhmad]

Hi Prakeet,

output should be

Issuance / Sold	Reciept / Purchased

Best Regards,

Shabir Ahmad

[Waqas_BIspecs]

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 😐

[Prateek97]

Hi @shabirAhmad ,

You can use following:

Flag = IF([StatusIssue]="Sold","Issuance",
                     IF([StatusIssue]="Purchased","Receipt",

                              "NA"))

Please mark this as solution if it solves your problem 🙂

[shabirAhmad]

Hi Prateek,

Thanks for your reply, actually there will be 2 fields in Report 1 field showd show Inventory Issuance and another field will show inventory Receipt.That means issuance field should show inssuance(Status::Sold) and Reciept field should show (Status::Recipt) reciept in report.

Best Regards,

Shabir Ahmad

[Prateek97]

Hi @shabirAhmad ,

Can you please give the table structure and the sample output in a table format. That would help to understand the issue better

[shabirAhmad]

Hi Prateek

output should be in report like this as below