Cannot perform an aggregate function on an expression containing an aggregate or a subquery.
I am having problems using the ratio pre-built advanced function. Here is an example of setting up a ratio to calculate price per gallon:
This one works. When I go to test the function it aggregates exactly as I would expect when aggregating multiple records:
Here I am trying to set up another ratio, this time to calculate an on time performance ratio:
Now when I try to test it, I get this cryptic error message and YellowFin is trying to perform a summation on my ratio or something:
How can I get YellowFin to stop trying to sum my ratio? The YellowFin wiki has no documentation on these pre-built functions: https://wiki.yellowfin.bi/display/USER74/Calculated+Fields