turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Dojo
- :
- Using Domo
- :
- Beast Mode, ETL/Dataflow
- :
- Re: New User: Calculated Field Sum Error; Cannot f...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

02-11-2018
01:24 PM

02-11-2018
01:24 PM

This is an elementary function, and I appear to be doing it correctly, yet I cannot get the correct outcome. I am using beast mode to add a calculated field, which combines the value of 2 raw data fields. However, the calculated field, no matter what I do, always returns blank values instead of a calculated value. What am I doing wrong here? See screenshots of data table and calcuation.

The calculated field is "Club Access Revenue," which results from adding the "cash" and "credit" fields. Row 1 should equal 22, row 2 rhould equal 22, row 3 should equal 20, etc. But they're all blank.

Labels:

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

02-13-2018
08:09 AM

All Replies

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

02-12-2018
02:24 AM

02-12-2018
02:24 AM

Hi,

Try this :

SUM(IFNULL(`cash`,0) ) + SUM(IFNULL(`credit`,0) )

Hope this helps, tell me how it goes.

**Ricardo Granada**

MajorDomo@Lusiaves

**If the post solves your problem, mark it by clicking on "Accept as Solution"

**You can say "Thank you" by clicking the thumbs up in the post that helped you.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

02-12-2018
04:42 PM

02-12-2018
04:42 PM

Thanks for the input. That formula gave me the result of 22+0=924. So, still trying to figure it out. Thanks.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

02-13-2018
08:09 AM

Highlighted
##
##### Re: New User: Calculated Field Sum Error; Cannot find resolution documentation

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

02-13-2018
08:13 AM

02-13-2018
08:13 AM

What does that data look like under this beastmode? There must be multiple rows of data for each CheckIn. If you use the aggregate SUM() function, it is going to total them all up, not just that one row.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

02-13-2018
08:38 AM

02-13-2018
08:38 AM

This worked. Thank you so much for the help!

Announcements