Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Nesting IIF(), is this possible
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00547335
Message ID:
00547360
Views:
14
Vlad,

It was a statement and incorrect one, not a sugestion .

>As I said, it was just a suggestion. I did not seen any other reason for syntax error. In addition, did you tested this in old Fox Pro that is used in this thread? I'm interested also to know for sure.
>
>>>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"
>>>
>>How did you came to such conclusion? The report engine works fine with values like ".5"
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform