I need help writing a Formula for an Aggregated Field in a Group by that will select the Latest Invoice that has an "A" in it if it exists. This example only has 1 Credit and Adjustment (C & A Invoice…
The beast mode below is not calculating correctly in the Grand Total Column. CASE WHEN SUM(IFNULL(`Billed Amount`,0)) = 0 THEN 0 ELSE (((SUM(IFNULL(ABS(`Billed Amount`),0))) - (SUM(IFNULL(`Actual Mate…
Using the Beast Mode below I am being forced to use the ABS function in order for the Beast mode to give me a calculation. If I remove the ABS Function I get the error "An issue has occurred during pr…
I need this Table to Sort by the Sub Total in the Total Column. But the CustName is being forced into the SORTING Option because I have selected SubTotal Rows. But I need SUBTotals selected because Ea…
Why is "# Houses" Column Total Greater than Sum of ROWS on "Closed Punch Tickets by Plumber" Card BEAST MODE for "# of Houses": COUNT(DISTINCT(CASE WHEN JT158_WTParent = 'Y' AND HdrParentItemCode = 'Z…
Why is AVG Punches Per House giving a total of Column and not Avg but PUNCH SCORE Column Total is giving AVG. PUNCH SCORE Beast Mode 10 * (COUNT(DISTINCT SalesOrderNo) / COUNT(DISTINCT sonum_wtnumber)…
The Following Beast Mode is reversing 1 & 2 & 4 & 5 for some reason. Only Field in the correct position is Material. I have checked spelling and case of field names.
I need the Subtotal and Totals of % Spent Columns to be averaged not Totaled fyi - transactionamt = JTD Cost (IFNULL(CASE WHEN SourceCode = 'Blank' THEN Filter Rows.TransactionAmt end,0))/ CASE WHEN (…
ELSE portion of Beast Mode Not Calculating Correctly It should be showing 1,015.56 but instead it is showing Zero. You can see the TA Column has broken out the Else Portion of the CASE statement and p…
BEAST MODE - % SPENT (IFNULL(case when `SourceCode` = 'AP' then `TransactionAmt` end,0)) / (IFNULL(`ProjTotalCostEOJ 1`,0)) fyi - Transaction Amount = JTD and ProjTotalCostEOJ1 is a column brought in …
BEAST MODE – AMOUNT LEFT CASE WHEN (IFNULL(`RevisedEstimatedCost`,0)) >= (IFNULL(case when `SourceCode` = 'AP' then `TransactionAmt` end,0)) THEN (IFNULL(`RevisedEstimatedCost`,0)) - (IFNULL(case when…
I have a Beast Mode that is not Calculating when one of the Values is ZERO. In this example Projected Cost Should be 21,192 based on the Beast Mode Equation but instead is returning a ZERO Value. BEAS…
I have a Column Phase InVoice Total that is not summing correctly compared to the other Columns and I can not figure out why. Anyone have any thoughts? Here is the Card and Portion of the ETL that cre…
I need to create a new Column via Beast mode called % Sales Material based on the following calculation. (Sales Price - Actual Cost) / Sales Price I am struggling with the exact Beast Mode Code becaus…
Can not get this ETL Formula to Validate CASE WHEN HdrParentItemCode IN ('ZROUGHIN', 'ZWATER', 'ZSEWER', 'ZROCK', 'ZVANGUARD') THEN 'Rough-IN' ELSE CASE WHEN HdrParentItemCode IN ('ZTOPOUT', 'ZGAS') T…
