If/Then Field Calculations

2887
10
Jump to solution
07-29-2021 04:19 AM
Labels (3)
FynnScharpen
Occasional Contributor

Good evening,

I'm searching for help regarding field calculations. 

I have a column called NVT which divides the total amount of points into groups. 

The query shall divide the points having the same NVT number into groups of 32.

The division into subgroups of 32 is consistant. the amount of points per NVT isnt

For Example: NVT 1= 96 points --> NVT 1 shall become 3 subgroups. 

NVT1: 

Points 1-32 get LFD3 =1 

Points 33-64 get LFD3 = 2 

Points 65-96 get LFD3 = 3

Same for NVT2 and NVT 3 and so on.

Thanks in advance 🙂 Hopefully my explanation is okay!

 

Zuweisung.PNG

Tags (3)
0 Kudos
10 Replies
FynnScharpen
Occasional Contributor

Thank you so much! There is so much I can learn.

Enjoy your garden time and have a joyful weekend. Off to new challenge 

 

Kind regards, Fynn

0 Kudos