1. ProfitLoss: IIF(IsNull([Sales Total Amt] - [Purchase Total Amt]), Null, IIF(([Sales Total Amt] - [Purchase Total Amt]) = 0, 0, IIF(([Sales Total Amt] - [Purchase Total Amt]) < 0,"-","+")))
I have tried to run the query it is asking me SalesTotalAmt, PurchseTotalAmt
2. ProfitLoss: IIf(IsNull([TTranscatType(SalesTotalAmt)]-[TTranscatType(PurchaseTotalAmt)]),Null,IIf(([TTranscatType(SalesTotalAmt)]-[TTranscatType(PurchaseTotalAmt)])=0,0,IIf(([TTranscatType(SalesTotalAmt]-[TTranscatType(PurchaseTotalAmt])<0,"-","+")))
TTranscatType(SalesTotalAmt)
TTranscatType(PurchaseTotalAmt)
TTranscatType(SalesTotalAmt], 3 [Unknown] = [TTranscatType(PurchaseTotalAmt
TTranscatType(SalesTotalAmt)
TTranscatType(PurchaseTotalAmt)
TTranscatType(SalesTotalAmt], 3 [Unknown] = [TTranscatType(PurchaseTotalAmt
TTranscatType(SalesTotalAmt)
TTranscatType(PurchaseTotalAmt)
TTranscatType(SalesTotalAmt], 7 [Unknown] = [TTranscatType(PurchaseTotalAmt
3. ProfitLoss: IIf(IsNull([TTranscatType/SalesTotalAmt)]-[TTranscatType/PurchaseTotalAmt)]),Null,IIf(([TTranscatType/SalesTotalAmt)]-[TTranscatType/PurchaseTotalAmt)])=0,0,IIf(([TTranscatType/SalesTotalAmt]-[TTranscatType/PurchaseTotalAmt])<0,"-","+")))
TTranscatType/SalesTotalAmt)], 1 [Unknown] = [TTranscatType/PurchaseTotalAmt)], 2 [Unknown] = [TTranscatType/SalesTotalAmt], 3 [Unknown] = [TTranscatType/PurchaseTotalAmt
TTranscatType/SalesTotalAmt)], 1 [Unknown] = [TTranscatType/PurchaseTotalAmt)], 2 [Unknown] = [TTranscatType/SalesTotalAmt], 3 [Unknown] = [TTranscatType/PurchaseTotalAmt
TTranscatType/SalesTotalAmt)], 5 [Unknown] = [TTranscatType/PurchaseTotalAmt)], 6 [Unknown] = [TTranscatType/SalesTotalAmt], 7 [Unknown] = [TTranscatType/PurchaseTotalAmt
Too few parameters. Expected 0
4. [Sales Total Amt] - [Purchase Total Amt]
Enter parameter value
SalesTotalAmt
PurchaseTotalAmt
I think Sales, Purchase are from field : TTranscatType for the reason it may be showing error.
Can you please help.
Further in alias TotalAmt the data shown is fraction of two digits only can you explain me pelase.