Comments
-
@DashboardDude I want the years offset to change, since it needs to be based on the quarter being shown also. I am hoping the explanation above is enough to give you two and anyone else reading this a better idea.
-
@RobSomers Not really, everything being used is already being shown. The bigger picture is that I am trying to fix a dashboard that is set up to show data from the Previous Quarter, the QtD portions of it work fine, but the YtD functions do not. Those two recent examples are calculations I am currently using and that also…
-
@RobSomers okay, so we have a Quarter Offset and a Year Offset, the quarter offset is always going to be -1, while the year will fluctuate between 0, -1, and -2 I believe based on what quarter it currently is, while that calculation works on it's own, it does not work once added to the rest. Here is what it needs to switch…
-
@RobSomers Yes it is, also this works, so hopefully now I can get the entire thing to work, thank you. Will comment on whether it works or not.
-
@RobSomers The beast mode is needing to effect the Year Offset based on what quarter of the year it is currently since part of the card I am making changes and uses data for only that quarter. It is to show the previous quarter, I have two different calculations I am using but they only work depending on the time of year,…