Skip to Content
0
Jun 05, 2009 at 11:09 AM

If condition in the query designer

31 Views

Hi friends,

I have requirements to do the formula/If condition in the query designer level,

The requirements is, I'm reading data from the multiprover, in my query i've fied as follows,

In Rows, PO NO, PO Itm, PO Currency

In column, PO value, PO qty,

I'm reading multiple currencies from the Multiprovider/Source, but when I display data for of the Currecy values, It has calluculate /100. e.g: PO 100, Currency IDR, PO value 150 so the logic is should be, like this,

If Currency "IDR"

Value"150/100"

If not default(value).

Can we do this kind of formula in the query desginer level.

SIRI