How to get the value from the source without time dimension
Hi, question please. I am doing a test variance module between line items of IC Run, Actual and Forecast using LIS, Versions and Project as my dimensions. I need to get the value of IC run, however, the module does not have time dimension in compare with my module data for the actuals and latest budget (forecast). I used the collect however, all the months are getting the values of 784M and sums all the periods that is why I am getting 6B. I just need the value of 784 as the totals for all the periods.
Test variance module
IC Run data - no time dimension