Need help with Calculation on a custom field | Adobe Higher Education
Skip to main content
Srinija_N
Srinija_N
Level 7
March 25, 2025
解決済み

Need help with Calculation on a custom field

  • March 25, 2025
  • 2 の返信
  • 467 ビュー

I have two Dropdown fields called 'Row' and 'Column' on my custom form. Field 'Row' holds the dropdown values 1,2,3,4,5,6,7,8 and Field 'Column' holds the dropdown values 1,2,3 and I need a calculated field called 'Total' with the below conditions:

 

The calculation of row + column should follow in this format:
Row 1 + Column 1 = 1
Row 1 +Column 2 = 2
Row 1 +Column 3 = 3
Row 2 +Column 1 = 4
Row 2 +Column 2 = 5
Row 2 +Column 3 = 6
Row 3 +Column 1 = 7
Row 3 +Column 2 = 8
Row 3 +Column 3 = 9
Row 4 +Column 1 = 10
Row 4 +Column 2 = 11
Row 4 +Column 3 = 12
Row 5 +Column 1 = 13
Row 5 +Column 2 = 14
Row 5 +Column 3 = 15
Row 6 +Column 1 = 16
Row 6 +Column 2 = 17
Row 6 +Column 3 = 18
Row 7 +Column 1 = 19
Row 7 +Column 2 = 20
Row 7 +Column 3 = 21
Row 8 +Column 1 = 22
Row 8 +Column 2 = 23
Row 8 +Column 3 = 24

 

Please advise!

ベストアンサー Srinija_N
 

To avoid a huge calculation which will not be scalable for any future changes, below is the pattern/formula that we came up with and works well with a short nested IF condition.

 

row=1, row*column

column=3, row*column

column=2, ((row*column)+(row-1))

column=1, ((column+1)row+(row-2))

 

Calculation:

if(row=1, row*column, if(column=3, row*column, if(column=2, ((row*column)+(row-1)), if(column=1, ((column+1)row+(row-2)), NA))))

2 の返信

Rafal_Bainie
Community Advisor
Rafal_BainieCommunity Advisor
Community Advisor
March 25, 2025

Given how clear your question was AI did spit out the answer 🙂 I admit I didn't verify, but usually it's pretty good with calculated fields:

 

    Srinija_N
    Srinija_N作成者
    Level 7
    March 25, 2025

    Thank you for this!

    I will try this out, hope this works!

    Srinija_N
    Srinija_N作成者
    Level 7
    March 28, 2025

    Only way is to have a big nested IF condition on the calculated field.

     

    IF(field row = 1,IF(column=1,1,IF(column=2,2,IF(column=3,3,0))),
     IF(field row = 2,IF(column=1,4,IF(column=2,5,IF(column=3,6,0)))
     IF(field row = 3,IF(column=1,7,IF(column=2,8,IF(column=3,9,0)))
     IF(field row = 4,IF(column=1,10,IF(column=2,11,IF(column=3,12,0)))
     IF(field row = 5,IF(column=1,13,IF(column=2,14,IF(column=3,15,0)))
     IF(field row = 6,IF(column=1,16,IF(column=2,17,IF(column=3,18,0)))
     IF(field row = 7,IF(column=1,19,IF(column=2,20,IF(column=3,21,0)))
     IF(field row = 8,IF(column=1,22,IF(column=2,23,IF(column=3,24,0)))
     )))))))

    Srinija_N
    Srinija_N作成者回答
    Level 7
    March 28, 2025
     

    To avoid a huge calculation which will not be scalable for any future changes, below is the pattern/formula that we came up with and works well with a short nested IF condition.

     

    row=1, row*column

    column=3, row*column

    column=2, ((row*column)+(row-1))

    column=1, ((column+1)row+(row-2))

     

    Calculation:

    if(row=1, row*column, if(column=3, row*column, if(column=2, ((row*column)+(row-1)), if(column=1, ((column+1)row+(row-2)), NA))))
    契約条件Accessibility statement

    Loading footer...