Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Good day,
I would like to create a desktop indicator with data that is updated from an excel sheet (fast updates but not necessarly real time but every minute let's say). This indicator would only consist of an exchange rate and an amount of money. I would like to be able to visualize it like I visualize my desktop clock or window toolbar.
At the place I'm working, we use contracts to cover our foreign sales. It is important for us to be able to see how much money is there left on the contract.
Ex: 1.354623 / 78 000$
Then if I create a foreign sale invoice of 8 000$, the amount would shrink to 70 000$. By this I know when to buy the next contrat.
Thank you
Would it be possible to create such an indicator ? Could I share it on my collegues computer desktop ?
Thank you
@xsanchezwsca wrote:
Good day,
I would like to create a desktop indicator with data that is updated from an excel sheet (fast updates but not necessarly real time but every minute let's say). This indicator would only consist of an exchange rate and an amount of money. I would like to be able to visualize it like I visualize my desktop clock or window toolbar.
At the place I'm working, we use contracts to cover our foreign sales. It is important for us to be able to see how much money is there left on the contract.
Ex: 1.354623 / 78 000$
Then if I create a foreign sale invoice of 8 000$, the amount would shrink to 70 000$. By this I know when to buy the next contrat.
Thank you
Would it be possible to create such an indicator ? Could I share it on my collegues computer desktop ?
Thank you
I'm not getting what eactly you'd like to do, when creating a sale invoice of 8000$, why "1.354623 / 70 000$" instead of "8001.354623 / 78 000$"?
For further suggestion, please post some sample data, expected output and more explanation of your scenario.
Good day,
Thank you for answering.
1.354623 is the exchange rate
78 000$ is the amount left to protect the future foreign sales at that exchange rate.
It could also appear like : 78 000$ @ 1.354623
I just want to be able to see what is my exchange rate and how fast the amount is shrinking.
Then when I am under 10 000$, I know I should buy another 100 000$ contract to protect the sales and that contract has another exchange rate...
I just want to see two datas coming from an excel sheet in a fast-way...Like the clock in my windows desktop.
It could have been something else like wheater or stocks quotations...
Is it clear ?
Thank you
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |