Forum Discussion
Help with calculated column based on two other columns
Hi all, Need some help calculating a column based on the contents of two other fields. The data I have is historical sales, but also mixed with budget data So for each product I have a busin...
Pragati11
Super User
Super UserHi dkoepke ,
Can you please post some sample data along with the required output? It's will make easier to answer your query.
Thanks,
Pragati
Data Type Year Month BU Qty SalesAmt Local Currency Model MonthlyReport 2019/12 DUS 3 50673 52D MonthlyReport 2019/12 DUS 1 17179.5 52D MonthlyReport 2019/12 DUS 41 678661.05 52D Budget 2019/12 DUS 4 55600 52D Budget 2019/12 DUS 3 45700 53D Budget 2019/12 DUS 40 62600 52D MonthlyReport 2019/12 DAS 2 30000 52D MonthlyReport 2019/12 DAS 4 40000 52D MonthlyReport 2019/12 DAS 5 42000 52D Budget 2019/12 DAS 1 4500 53D Budget 2019/12 DAS 1 4500 53D Budget 2019/12 DAS 1 4500 53D
