Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Count Moving Average Unit Cost (MAUC) in script on the certain date

Hello,

I have a table:

DATEITEMMOVEAMOUNTACTUAL STOCK (quantity)PRICEACTUAL STOCK (money)MAUC
1.3.2020M01Income5515 €1 €
7.3.2020M01Income510215 €1,5 €
9.3.2020M01Expenditure281,512 €1,5 €
17.4.2020M02Income33515 €3 €
19.4.2020M02Income69433 €3,6667 €
7.5.2020M01Expenditure351,57,5 €1,5 €
7.5.2020M02Income110538 €3,8 €

 

INCOME - is calculated in MAUC

Expenditure - is always in actual value of MAUC

How can I calculate value of MAUC in different time period ?

For example MAUC for M02 in 17.4.2020 is 3 € and in 7.5.2020 is 3,8 €. 

Thank you 

 

 

Labels (2)
6 Replies
Highlighted
Master
Master

@jozisvk11 

what is the formula you use for MAUC calculating ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

MUAC is based off of PRICE column? If it is, then on 17.4.2020, are you doing 1 (1.3.2020) + 2 (7.3.2020) + 5 (17.4.2020) divided by 3? If that is true, then 8/3 should be 2.66667? If that is not what you are doing, then what is the calculation which gives you 2 here?

Highlighted
Creator
Creator

Highlighted
Creator
Creator

Hello,

here is a link, how is MAUC calculated - https://docs.infor.com/ln/10.3/en-us/lnolh/help/wh/onlinemanual/000347.html

Highlighted
Creator
Creator

17.4.2020 is another item M02. 

Highlighted
Creator
Creator

Sunny, could you give me some solution ?

Thank you