I want to get a summary of a summary tables results. My example is below.
I summarize the total of the t30Ticks field in the bottom table in the summary table above. But if the sum is less than -100, I use the t30Adj field for the days projected results with a min value of -100.
But I can’t figure out how to add up the t30Adj field to see what the monthly results are for the t30Adj column. I can do it for the t30Ticks field by making a summary table of the Trades table. But I need to summarize the trades table by day to see if the day needs to be adjusted to -100.
I’m sure there is a formula set that gets me there but I can’t figure out what it might be
thanks