Qlik Community

Qlik Sense App Development

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

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
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") 😉
Highlighted

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?

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