How to know the way DOMO beast mode 'calculated field' is calculating?

Options

In order to solve the problem at Summary Number, I simplify the data.

below is the description of the problem:

below is the simplified data:

2024-4-1, data is 1.32, which is what I want to show.

2024-4-2, data is 2.32, which is what i want to show.

In Summary Number area, I want the average, that is (1.32+2.32)/2=1.82

but the Summary Number is 1.888

the calculated field for summary number is (sum (DISTINCT托盘库位数折算) fixed( byStorage Location Name,Storage Date)) * (COUNT(DISTINCT Storage Location Name) fixed (by Storage Date))

Why the average data is not what I want? what is the problem with my design?

Looking for help!

thanks

Best Answer

  • Sean_Tully
    Sean_Tully Contributor
    edited May 17 Answer ✓
    Options

    Try just sum, not sum(DISTINCT), if you have 2+ rows with the same value sum(DISTINCT) would only use one of them in the calc.

Answers

  • Sean_Tully
    Sean_Tully Contributor
    edited May 17 Answer ✓
    Options

    Try just sum, not sum(DISTINCT), if you have 2+ rows with the same value sum(DISTINCT) would only use one of them in the calc.

  • luyennguyen
    Options

    This case my suggestion we can process using SQL in DOMO