none
create dynamic measure column - search value from table[col] RRS feed

  • Question

  • Hello

    Data contains item in stock profile (date and qty added) and use up profile (date and qty used)- based on these data I would like to create dynamic measure column (qty_done_by) that specify when stock qty would be used up.  Data can be in same table or two different tables. 

    TABLE-A       TABLE-B        
    RCV RCV_Qty RCV_Cum_Qty   USE_BY USE_Qty USE_Cum_Qty   Qty_Done_by
    201824 120 120   201827 145 145   201827
    201825 360 480   201828 274 419   201829
    201826 1794 2274   201829 258 677   201836
    201827 240 2514   201830 387 1064   201836
    201828 960 3474   201831 289 1353   201839
    201829 120 3594   201832 296 1649   201839
    201830 480 4074   201833 215 1864   201841
    201831 600 4674   201834 302 2166   201844
    201832 1080 5754   201835 101 2267   201845
    201833 360 6114   201836 257 2524   201847
    201834 120 6234   201837 345 2869   201848
    201836 120 6354   201838 310 3179   201848
    201838 360 6714   201839 460 3639   201849
    201839 240 6954   201840 372 4011    
    201840 240 7194   201841 150 4161    
    201842 1080 8274   201842 231 4392    
    201843 240 8514   201843 176 4568    
    201844 720 9234   201844 571 5139    
    201845 120 9354   201845 727 5866    
    201846 480 9834   201846 224 6090    
    201847 240 10074   201847 122 6212    
    201848 240 10314   201848 161 6373    
    201851 960 11274   201849 587 6960    

    Thank you 

    Tuesday, January 1, 2019 1:59 AM

Answers