Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart object "KPI" where I fill in manually a number like '10', which I need to change on a daily base.
I also have a different chart "Table" where in the expression I need to include the hardcoded value. Example of an expression: Sum([AR USD]) * '10'.
Is there a possibility to have a get field selection for the hardcoded number in the expression so I only need to update the KPI and all different expressions related to this KPI will be changed automatically. Like something Sum(AR USD) * 'GetHardCoded value in KPI'.
A variable will not work in this case as due to security reasons this option is close.
Thanks for all the great help.
Ugur
If not variables, You can try with the extension objects as we do not have option for input field in Sense...
Check this link....
Try this?
Sum(AR USD) * Pick(Match(DateField, 'Today', 'Yesterday'), 10,20)