Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
jakob_hansen
Partner - Contributor
Partner - Contributor

rangesum in script

Hi

How can i transform this expression to be used in the script?

Thi thing i want to create is a R12 average of DPO_Weighted_Days_Total per YearMonth

if((rangesum(Above(sum({1<Supplier_DWID={Total}, Year=, Month=>}Counter_YearMonth),0,12)))=12,

rangesum(Above(sum({1<Supplier_DWID={Total}, Year=, Month=>}DPO_Weighted_Days_Total),0,12))

/12)



0 Replies