Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello..
is there any previous function that i can use for expression in a chart table instead of below or above?
i have a case that i have 3-days-group which is 1 day of group have 3 days
so i have to do max(curr_value)-max([yesterday_value])
i've tried max(curr_value)-prev(max(curr_value))
but there is no effect and no value show up
so how to use previous function in chart table expression?
many thx...
Hello,
Previous() function works record wise, so it won't work in a pivot table. Why don't you want to use inter-record above(), below() (rows) after(), before() (columns) functions. If there is a dimension for any day, these functions will work fine. Depending on the dimensions you can use set analysis, though.
Say you have Day as dimension (row), sorted ascending and
as expression for the current value. ThenSum(Value)
will return the sum for the previous day.above(Sum(Value))
If the dimension is a group of three days, and this is linked to a master calendar, then you can use set analysis like (untested)
Sum({< Day = {'$(=aggr(max(Day), GroupOfThreeDates) -1)'} >} Value)
Regards.
hello Miquel..
i've tried with below() function but the result is not correct
and i also have tried with syntax below :
Sum ({$<DayGroupThree={"$(=max(DayGroupThree)-1)"}>}
aggr(max(curr_value)-min(curr_value),DayGroupThree_sci)
)
but the result is also not showing the value before today
i really need a help...
many thx..