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 |