Infoset Query Question

[Former Member]

I created an Infoset Query showing Quantity, Net Value and Exchange Rate. Is it possible to add a field to add a calculation NetValue*ExchangeRate?

Thanks,

Dipen.

[Former Member]

I created an Infoset Query showing Quantity, Net Value and Exchange Rate. Is it possible to add a field to add a calculation NetValue*ExchangeRate?

Thanks,

Dipen.

[Former Member]

Hi

Yes you can.

Go to EXTRAS section: here you can add additional fields and write the code you need to poplute them.

Max

[Former Member]

This is how you do this. Goto SQ01. Go to the next screen till you come to FIELDS section. Here in the menu <i>EDIT</i> you will get an option of <i>Short names->switchon/off</i>. Click and enter short name for Net value and Exchange rate.

Then use the option in the menu

<i>Local fields->Create</i>. Enter the name of the local field, description,heading. Select a suitable attribute for the field.Select <i>Complex calculation</i> and click on the button. Here you can put condition if you want to otherwise enter formaula using short names in the Otherwise section. This local field will now start appearing in the fields section. You need to selct this and use it.

Hope this helps.