I am not sure what is the purpose of your requirement. You can simply implement the calculation in macro itself ?? If you could explain the reason behind your requirement, we may suggest a better solution. But I don't want to disappoint you. Have a look at the attached file. If your file is a desktop application (reloading application from access point through button click will not work) then below attached file should work. Let us know.
QComm_291224.qvw 144.2 K
Thank you Exactly what I wanted.
But to explain the requirement in detail, I have a data table holding data for several months Column wise. In another table I have Exchange rates for various month for different countries.
Country Product JAN FEB MAR C1 P1 4 6 9 C2 P1 7 8 7 C3 P1 6 7 4 C3 P2 6 4 6 C4 P1 6 6 5 C4 P2 6 5 4 C4 P3 4 7 4
Country JAN FEB MAR C1 9 4 6 C2 7 6 5 C3 8 6 8 C4 8 7 6
What I am tyring to do now is to create another temp table based on my exchange rate month selection. I need standard rate to be applied. If I have selected MAR, then in Jan data also the match value to be applied.
So I needed an action where I can trigger a script to do that.