Recreate 2 Excel Formulas in DOMO (table provided)

Options
leeloo_dallas
leeloo_dallas Member
in Magic ETL

Can anyone match the exact results from the formulas in my excel spreadsheet? The 

 

Contribution: Is based off Rank

Effort: is based off Contribution

 

Formulas in Excel include:

Contribution: =SUM(A$2:A2)/SUM(A:A)

Effort = =F2/MAX(F:F)

 

The results need to be identical to the attached file. 

 

Categories