Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have a data named InvoiceTAT loaded from the database. I need to call this in a if condition in script area. can some one please suggest how the From statement should be?
TableName:
LOAD
Field1,
Field2,
...
If(Currency='Euro', SaleAmount*ExchangeRate, SaleAmount) as SaleAmount,
...
FROM DataSource;