Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I am applying an expression of rangesum below function to try to get the total detail value after a specific Cal Week as the value of Cal week, I use this expression
Concat(DISTINCT aggr( rangesum(below(sum(Detail), 1, 334)),[Cast Week],Material,Loc,[Cal Week]), '') ,
but it only works for first material, it doesn't work from second material, I have uploaded the qvw file. Can someone help me about this ?
Where in the app are you using the above function? I see this expression
RangeSum(Above(Sum({<Dimension, Date= {'$(vDate)'}>}Failed),0,RowNo()))*Avg(1)
But where can we see this and the issue related with it?
Concat(DISTINCT aggr( rangesum(below(sum(Detail), 1, 334)),[Cast Week],Material,Loc,[Cal Week]), '')
Hi Sunny,
Thanks for reminding, I think I uploaded the wrong qvw file, I attached the correct file, can you see it now?
Now my question is how to make expression that total of the details after the Cal week as the Rangsum of that Cal week
when Cal Week is greater than Cast Week , just like the attached screenshot:
So, cast week is 2018044 and you want to perform the rangesum only after that week? Also, cast week is not a number field... do you have another field like cast week which looks like cal week?
Hi Sunny,
I want to perform the rangsum when Cal Week is after 2018044, I updated the qvw file which cast week format is like cal week.
Does this look like what you wanted?
RangeSum(Before(If([Cal Week] >= [Cast Week], Sum(Detail)), 0, 334))
Hi Sunny,
Thanks for your expression, but it is not the expected result.
For an example:
For matl code AS72C/location code AU27:
from cal week 2018011 to 2018044, the expected value of Rangesum is 0 because only need to show value on cal week which is greater than cast week, cal week2018011 to 2018044 is not greater than cast week, so no need to show value of Rangsum or 0 for these cells ;
for cal week 2018051, its detail value 10248, but after cal week 2018051 all detail value is 0, so the Rangesum value on cal week 2018051 column is 0 because I need the details sum which cal week is greater than 2018051 till this row end.
I attached the expected result excel sheet, please check.
Something like the below
(sum(total<[Cast Week],[Rep Item],[Matl Code],[Location Code]> Detail) -
rangesum(before(sum(Detail), 0, ColumnNo())) ) * PurgeChar( [Cal Week]>trim(Replace([Cast Week],'WF','')),'-')
Hi Susant,
Thanks very much for your expression, it works! But I have additional requirement based on the Rangesum of each cal week, that is to
show Rangesum of period and the value is the 4th week of each period, for example:
for matl code BP42T/location code AU00, Rangesum of cal week 2018054 is 25164, I need this value shown in 201805 column when I switch the dimension Cal Period. I attached the qvw file, please check.
I don't understand your Excel file. All it is showing for Rangesum is 0 for all Cal Week