I am trying to write a report fro PA module; it is looking at Cost Categories and the PAProfit and PAbillings fields. However the user wants to see the financial information in the currency of the Project so if the entity I am reporting on has functional currency USD but the project is in GBP then the fields I need to report on are PAMCPAProfitAmt etc,....
So the logic I am looking for is
If PA01201.Currnidx not = to MC40000.funcridx
then PA01301.PA[PAMCBProfitAmt]
else PA01301.[PAProfitAmt]
I have all the joins looking at the tables; in reality what I am looking for is case statement that references fields and depending on the output selects fields rather than values!
I hope that this makes sense if not tell me and I will try and clarify.
Many thanks