9 Replies Latest reply on Jul 12, 2017 12:48 AM by Zhouyi Zhang

    How to use fixed function for a field which is calculated by table calculation

    Himanshu Sharma

      Hi Guys,

      I have opening stock as on first day of month, Receipt, Consumption and Min Stock required.

      I've calculated closing stock as below and need to fixed closing stock or closing status. when i am trying to fix closing status it is showing error " Level of detail expressions cannot contain table calculations".

       

      Cal.1 Change in Stock = [Receipt]-[Consumption]

      Cal.2 Closing stock= RUNNING_SUM(SUM([Opening Stock as on 1st]))+RUNNING_SUM(SUM([Change in Stock]))                 (table Across)

      Cal.3  IF [Closing Stock]< ATTR([Min Inventory level]) THEN 1 else 0 END

      Cal.4  Closing Status_Fixed ={ Fixed Plant,Material Code, Date: sum(  If Closing Stock<Min Inv then 1 else 0 end)} but it is showing error " Level of detail expressions cannot contain table calculations"

       

      Requirement : Need only those products for which at least once closing stock<Minimum Inventory level, numbers in pane will reflect no of such days

       

      Please suggest how can we fix closing stock or closing status.

      Thanks for the time and consideration