What should be the if expression in the report template

[Pointer]

Hi everyone,

What should be the if expression that I should use in the yellow and green (especially) cells in my report template in order to get the results in the diff line that I am trying to express in the picture. Thanks

@AleksiAlkio @Suvrutt_Gurjar @Marc_Dillon @WillowMobileSys @jaichith 

[Pointer · Accepted solution]

<<IFS(ISBLANK(ANY(SELECT(Report Table[Value], AND([_THISROW-1].[ID] = [ID], [_THISROW-1].[Date] =  [Date])))), "-",

AND(ISBLANK(ANY(SELECT(Report Table[Value], AND([_THISROW-1].[ID] = [ID], [_THISROW-1].[Date] =  [Date])))), 
MAX(SELECT(Report Table[Value], AND([_THISROW-1].[ID] = [ID], [_THISROW-1].[Date] = [Date]))) -MIN(SELECT(Report Table[Value], AND([_THISROW-1].[ID] = [ID],[_THISROW-1].[Date] = [Date])))>5),

SUBSTITUTE(TEXT(MAX(SELECT(Report Table[Value], AND([_THISROW-1].[ID] = [ID],[_THISROW-1].[Date] = [Date])))-MIN(SELECT(Report Table[Value], AND([_THISROW-1].[ID] = [ID],[_THISROW-1].[Date] = [Date])))),".",",")

AND(ISBLANK(ANY(SELECT(Report Table[Value], AND([_THISROW-1].[ID] = [ID], [_THISROW-1].[Date] = [Date])))), 
MAX(SELECT(Report Table[Value], AND([_THISROW-1].[ID] = [ID],[_THISROW-1].[Date] = [Date])))-MIN(SELECT(Report Table[Value], AND([_THISROW-1].[ID] = [ID],[_THISROW-1].[Date] = [Date])))<=5),

SUBSTITUTE(TEXT(MAX(SELECT(Report Table[Value], AND([_THISROW-1].[ID] = [ID], [_THISROW-1].[Date] = [Date])))-MIN(SELECT(Report Table[Value], AND([_THISROW-1].[ID] = [ID],[_THISROW-1].[Date] = [Date]))))".",","))>>

I solved it this way, thanks @Suvrutt_Gurjar @jaichith