help with multirow formula

Question

hello guys, I just want to determine if the student got low grade or high grade every week

IIF([Name] = [Row+1:Name]  AND [Grade.Rate]>[Row+1:Grade.Rate] , 'Grade went low', null())

DateNameGradePreferred result from the multi-row formula above2021-02-05Andre3Grade went low2021-01-22Andre5Grade went low2021-02-05Test3Grade went low2021-01-22Test5Grade went low2021-02-05Test53Grade went low2021-01-22Test56Grade went low2021-02-05Test66Grade went high2021-01-22Test63Grade went high

SeanAdams · Answer

In the multirow tool - you don't need to check the name.

Instead, set the grouping in the tool; and set the "value for rows that don't exist"

Then you can write a formula like:

if isnull([Row-1: Grade.Rate]) //meaning this is the first time

then "First time"

elseif [Row-1: Grade.Rate] < [Grade.Rate]

then "Grade increased"

elseif [Row-1: Grade.Rate] > [Grade.Rate]

then "Grade decreased"

else

"Grade same or other condition"

endif

messi007 · Answer

@Ultralightbeam,

Please see below how you can do it:

Attached the workflow,

Hope this helps!

Regards

MultiRow_20210223.yxmd

Assaf_m · Answer

Hi @Ultralightbeam ,

I would suggest using the Cross Tab tool,

check the attached solution and let me know if it works for you.

formula.yxmd