calculated measure not giving the result

Summary:

we are using Nvl expression in measure. it sums up the measure as following:

nvl(measure1, 0) + nvl(measure2, 0) + nvl(measure3, 0) + nvl(measure4, 0) + nvl(measure5, 0)

these measures use archival expression for past weeks onhand data corresponding to measure number

archival(onhand, week,1,"rolling) and so on.

but we see 0 value as output, even though measure1,2,3,4,5 have values.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):