Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have the following IF in a KPI, this uses > + < join in the expression
here is the expression
sum({1
<[WeekStartDate] = ,[WeekStart] = ,[Date] = {'>=$(=vMinWeek)'}> + <[WeekStartDate] = ,[WeekStart] = ,[OrderInProgress] = {0}>
}if([WeeksWaitedFlag] + vWeekAdjust = Weeks,CurrentWeekFlag,0))
I have in the load added {1} to the vMinWeek, with no joy, selections still affect the expression.
please help
May be add another 1 here
Sum({1<[WeekStartDate] = ,[WeekStart] = ,[Date] = {'>=$(=vMinWeek)'}> + 1<[WeekStartDate] = ,[WeekStart] = ,[OrderInProgress] = {0}>} if([WeeksWaitedFlag] + vWeekAdjust = Weeks,CurrentWeekFlag,0))
May be add another 1 here
Sum({1<[WeekStartDate] = ,[WeekStart] = ,[Date] = {'>=$(=vMinWeek)'}> + 1<[WeekStartDate] = ,[WeekStart] = ,[OrderInProgress] = {0}>} if([WeeksWaitedFlag] + vWeekAdjust = Weeks,CurrentWeekFlag,0))
Hi
Thanks team, star as always x
Kind Regards