abarrie23

Very helpful, thanks for the clarification.

in fixed functions in etl Comment by abarrie23 September 5

Thanks @JedP. That was helpful. Thanks to you as well @Jones01

in Solution: Beast Mode & Pivot Table Aggregation Error Comment by abarrie23 September 5

Hi @Jones01 I tried it. I'm still showing the same aggregation error. Is the formula below what you were suggesting? sum(CASE when Term Length (Months) > 0 then Term Length (Months) end) else (SUM(Term length (lookup)) FIXED (BY Document Number)) END

in Solution: Beast Mode & Pivot Table Aggregation Error Comment by abarrie23 August 29

Hi @JedP This problem is very similar to one i'm having currently. Any ideas on fixing the following case statement below? CASE when Term Length (Months) > 0 then Term Length (Months) else SUM(SUM(Term length (lookup)) FIXED (BY Document Number)) END

in Solution: Beast Mode & Pivot Table Aggregation Error Comment by abarrie23 August 29

Hi ahmedad No, there aren't any field values containing a/or. The plugin is inconsistent with the amount of data it pulls. Sometimes it pulls 50k rows, other times 100k rows. But it never downloads the entire 317k rows of the dataset.

in plugin not downloading entire dataset Comment by abarrie23 November 2021

abarrie23 Member

Comments