How are you expecting -135 and where?
I did this quickly, sorry, I actually meant -225 everywhere 15-240. Sorry, I'm actually having an even bigger problem connecting to postgres views. The tables are fine, views, not so much.
No, solved the view issue. Still haven't solve the functions on table functions
Holy good gravy! I must be the only one in America with these questions. Anyway, I found the solution. It is the realization that a table function of a table function are called nested table functions and when you have a table function of table functions, the "direction" of the inside table function has to be set on the outside table function
I have this:
total_delta = [total_actual] - [total_bc]
total_actual = total(sum(actual))
total_bc = total(sum(bc))
BUT if you put total_delta in the table with total_actual and total_bc, the computer does not look at the total_actual and total_bc values in table to calculate delta like it would a window function. It's like DAX. It recalculates total_delta from scratch even after it calculated total_actual and total_bc elsewhere in the table. Thus, you must set the directoin of both total_actual and total_bc individually here:
It used to be that words mean something, but in tableau, apparently variables do not. These aren't really variables, they're labels for underlying calculations. Stil
I was getting -225 , but you said -135 so I asked you that question earlier. But anyway, you got the answer through your efforts.