Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a data sheet (Stocklist) with example data and less columns
I made in Data Manager a new measure YTD, but I can't find the right expression for a YTD
Can anyone help me out on this, I included the data and the QVF
Please refer to this thread:
May be this?
RangeSum(Before(Sum(Value), 0, ColumnNo()))
But Sunny, that would only work if the order of the Period is maintained.
Well, It would work, but Eddy, try to understand how to create time functions.
Why do you think that period will not be sorted? Not sure I understand your concern
I just want him to understand how to write time expressions
Thanks Omar, I will read this and try it out
Hi Sunny, I will also try your solution, let's see what the best
Both thanks for the quick answer !!
Hi Sunny, thanks for answer it works well
@ Omar , I will sure read your answer
Thanks
Hi Sunny,
this works fine if there is data for all months , but I have periods with no data and then a get a dashin YTD, and by the next actual value i get a value in YTD again, but now the user wants, if no actual value to see a copy of the value before in YTD.
How can we proceed with months with no value, with if(… ) maybe ?
Can you help on this
Best regards