Hi!
It was just a suggestion. I do remember that something in VFP does not like the syntax like ".5", but do not remember exactly what. In addition, it is old Fox Pro...
>Hey Vlad,
>
>Amazing... I never cease to be impressed with the scope of knowledge you and many others here have.
>
>Renoir
>
>>Hi!
>>
>>Yes, it is possible :) The problem not in the nested IIF().
>>
>>IIF(hank.pla_level = '1st', IIF(HANK.PLA_WITH = 'Ideal',ROUND(HANK.AMOUNT *
0.3,2), ROUND(hank.amount*
0.275,2)), ROUND(hank.amount*
0.5,2))
>>
>>Report engine just does not like values like ".5"
>>
>>HTH.
>>
>>
>>>I am using the IIF() to get a value for a field in a report and need to nest the IIF(). Can this be done?
>>>The expression I am using for a field in a report goes something like this:
>>>
>>>IIF(hank.pla_level = '1st', IIF(HANK.PLA_WITH = 'Ideal',ROUND(HANK.AMOUNT *.3,2), ROUND(hank.amount*.275,2)), ROUND(hank.amount*.5,2))
>>>
>>>It looks good to me, however my logic may have a flaw I cannot find or nesting this type of expression may not be valid... I keep getting a 'syntax error'. I am sure there is an easier way to accomplish my goal, however, I would really like to know if nesting the IIF is possible and what I could be doing wrong? Any ideas would be great!
>>>
>>>Also, I am new at this please be kind :)
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.