7 Replies Latest reply: Dec 2, 2013 4:04 PM by alon coen RSS

    Key and calculated field

      HI,

      I need to make a comparison between the actual sales and the sales budget.

      in the Budget tab I createda calculated field:    Month(budgetMont) as Budget_Month it dosnt work from some rason.

      And the second field I created is key field : BudgetYear&'-'&Budget_Month&'-'&CategoryID as KeyCompare .

      The goal is to link the budget table and the sales table.-

       

      In Sales tab I created:  Year&'-'&Month&'-'&CategoryID as KeyCompare

      I created twice, once in sales table and once in SalesHistoty table.

      What is the problem? whay it dosnt work?

       

       

      Also, how can I create a calculated field  in sales tab?

      Example: QTY * COST