i am trying to pass values in my transition from one tab to the next.
1st tab: summary
2nd tab: financial analysis (FA)
on the summary tab, i have 2 tiles. the 1st tile has Gross Costs in it. and the 2nd has Deployed payroll.
on the financial analysis tab, i have just 1 tile object.
TO-BE: when the 'Gross Costs' tile is selected, i want to pass all the value to the financial analysis tab. and when the 'Deployed Payroll' tile is selected, i want to pass all the values on that specific tile to the tile on the 'financial analysis' tab.
PROBLEM: to pass the values, i created a variable that stores the formula called: v_VariableTransfer
the issue is, the values. when Gross costs is selected, it is passing the value to the FA tab. but it stores that value in the variable. this means that when i try to change the filter on the FA tab now, the value does not respond to any value changes.
i need to be able to pass the formula and not the number itself.
let me know if anyone has a workaround for this, or has had to do it before.thanks!