Subtract 1 from Column above based on another Column

[bleu]

Should be simple but I'm stuck again. Need some help here. Here's an example:

Letter    Scores
A          100-90
B          89-80
C          79-68
D          67-61
F          60-0

Output

Letter    Scores

A          100

A          99

A          98

A          97

etc...

I'm trying to generate some rows then use a multifield...

If it's already been done can you point me to a link, I can't find what I need right now.

Thanks guys,

bleu

[DavidP · Accepted solution]

Hi @bleu 

The way I would approach this is to use Text to Columns to split your Max and Min Score into 2 columns. You can then convert them to number data types and use Generate Rows to create the individual rows. Something like this:

[bleu]

Perfect!

Thanks so much DavidP!! 😁