ljos_14

in Is there any row_number or rank function in beast mode? Comment by ljos_14 January 2023

@adeshon Did you even find a solution for this? I am currently in the same debacle.

in Is there a way to aggregate the output using a FIXED function used in a CASE statement? Comment by ljos_14 January 2023

Success! AVG( case when SUM(`Spend`) FIXED (BY `Company`) > 0 then SUM(`Revenue`) FIXED (BY `Company`) end )

in Beast Mode: How to calculate Fixed Average dependent on a different Fixed Sum Comment by ljos_14 January 2023

ljos_14 Member