I have a Demo WS and Currency WS that Gowflow has helped me develop where when you change Currency, or change the Demo, it changes to the correct currency values. I have a change that needs to be made.
I have to tell you how this works first:
You select a "Currency" on the Customer-Input Tab and that automatically changes the currency values and formats throughout the model to reflect the right currency value and format. On the Demo Tab, you can select 3 different types of "Demos" (Conservative, Standard, and Aggressive) that also change the values and echo the new value and format through the model.
Here's what I need. In the Demos Tab, the values in the Table (Demo WS; col. E, F and G) may not be currency. They may be % or simply numbers. For this reason, they don't need to be converted.
In the case that the value that is imposed in "I" is not "currency", it needs to be reflected as that value and format in "J". In otherwords, in the Demo WS, it should only convert currency values; not other values.
Thank you in advance,