Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Percentage calculation in expression of report
Message
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00588031
Message ID:
00588174
Views:
22
Weird. What if you explicitly put field1+field2+field3+... instead of CalCrpt() in ValueToStore for this variable? It should work, I think.

You may want to send this report to me, I'll check it...

>Hi Nadya,
>I created the report variable named it nCalCrpt and put the "Value to store" as CalCrpt() and when the report is run it reads: "File nCalCrpt.prg does not exist"
>I placed the expression "iif(nCalCrpt+Field1+Field2>0, nCalCrpt/(nCalCrpt+Field1+Field2)*100,0)" as the 'Expression for Field on Report' but
>I wasn't sure if this was what I was supposed to do so then I created the nCalCrpt.prg with the expression above and named the field on the report nCalCrpt() and it gave the error "File nCalCrpt.prg does not exist."
>Thanks!
>Max
>
>> Where do you use your expression?
>> Create a Report varaible called nCalCrpt
>> Set it to be CalCrpt()
>> Release at the end of report (this, unfortunately, has some bug, but it's not relevant here)
>
>> Your expression now would be: (check for possible division by 0)
>iif(nCalCrpt+Field1+Field2>0, nCalCrpt/(nCalCrpt+Field1+Field2)*100,0)
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform