9 Replies Latest reply on Sep 4, 2018 1:34 PM by Raj Chattarki

# Building Custom Formulas for Calculation

Hey Community!!

I need to create a custom calculation off of the columns! The formula I want to build is something like this:

Any help would be greatly appreciated!

Thanks!

Best,

Raj

• ###### 1. Re: Building Custom Formulas for Calculation

HI Raj,

Hope this helps.

Level of Detail Expressions

Table Calculation Functions

Thanks,

shin

• ###### 2. Re: Building Custom Formulas for Calculation

Hey!

Thanks for the comment, but I don't think that's what I'm looking for. Sorry If I'd framed the question wrong. I've attached the pictures as to how this dynamic calculation would work.

1)

2)

3)

4)

After these are calculated the following is then calculated.

• ###### 3. Re: Building Custom Formulas for Calculation

Shin

• ###### 4. Re: Building Custom Formulas for Calculation

Is this what you are looking for?

Here are the 2 calculated fields used above:

Running Average: RUNNING_SUM(SUM([Score]))/RUNNING_SUM(SUM([Total Attendees]))

Average of Running Average: RUNNING_AVG([Running Average])

Both the above table calculations are computed using Table Down.

Workbook attached for reference.

Hope this helps.

1 of 1 people found this helpful
• ###### 5. Re: Building Custom Formulas for Calculation

Awesome!! Thank you so much!!

Raj

• ###### 7. Re: Building Custom Formulas for Calculation

Hey Hari,

Thank you so much for the answer. This helped me solve the calculation part! Figuring out the visualization part. I'm running into a red dead stop, where nothing is visible.

What I want to show:

Current issue:

Nothing is on the display!

Thanks again!

Best,

Raj

• ###### 8. Re: Building Custom Formulas for Calculation

If you can provide your packaged workbook (twbx), I can look into it.

• ###### 9. Re: Building Custom Formulas for Calculation

Thank you so much! It was a silly error, fixed it

Best,

Raj