P
Paul
I am stuck on something that seems fairly straightforward but haven't
found a solution anywhere! I understand that calculated fields are
temporary and the data is not stored as such. But I figure the
calculation is done when another command requests the information.
However this does not seem to be the case here:
Test Total before VAT NIS: IIf([Currency]="GBP",[Exchange
rate]*(([Hourly rate]*([Hours]))+[Fixed price]),([Hourly
rate]*([Hours]))+[Fixed price])
Test Invoice Total NIS: [Test Total before VAT NIS]*([VAT rate]/100)
The second field has a calculation based on the first field. However
when I try to run it, I get the error "Enter Parameter Value: Test
Total before VAT NIS" and a field to enter the value. It seems to me as
though the second field is not asking the first for a value or that
they are being run in the wrong order. I am a real newbie so if I'm
being an idiot, please tell me!
(By the way, I realise the field names are less than optimal but for
now I'm just messing around)
Thanks in advance!
Paul
found a solution anywhere! I understand that calculated fields are
temporary and the data is not stored as such. But I figure the
calculation is done when another command requests the information.
However this does not seem to be the case here:
Test Total before VAT NIS: IIf([Currency]="GBP",[Exchange
rate]*(([Hourly rate]*([Hours]))+[Fixed price]),([Hourly
rate]*([Hours]))+[Fixed price])
Test Invoice Total NIS: [Test Total before VAT NIS]*([VAT rate]/100)
The second field has a calculation based on the first field. However
when I try to run it, I get the error "Enter Parameter Value: Test
Total before VAT NIS" and a field to enter the value. It seems to me as
though the second field is not asking the first for a value or that
they are being run in the wrong order. I am a real newbie so if I'm
being an idiot, please tell me!
(By the way, I realise the field names are less than optimal but for
now I'm just messing around)
Thanks in advance!
Paul