chevyimpala
Programmer
I have this report called performance, and I have a column in my query with this calculation:
Sum Of Size: IIf([Current Pos]<>0,0,Sum(IIf([Curr]="EUR" Or [Curr]="GBP" Or [Curr]="EUR/JPY" Or [Curr]="EUR/GBP",[Size]*-1*[Rate],IIf([Curr]="CHF" Or [Curr]="JPY",[Size]*-1/[Rate]))))
now why is it that when I run it in my report called currency with the same cal. I get a totaly different number in my performance report.
The performance report query is running as a group by and the currency is a select.
thx.
Sum Of Size: IIf([Current Pos]<>0,0,Sum(IIf([Curr]="EUR" Or [Curr]="GBP" Or [Curr]="EUR/JPY" Or [Curr]="EUR/GBP",[Size]*-1*[Rate],IIf([Curr]="CHF" Or [Curr]="JPY",[Size]*-1/[Rate]))))
now why is it that when I run it in my report called currency with the same cal. I get a totaly different number in my performance report.
The performance report query is running as a group by and the currency is a select.
thx.