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:
00588171
Views:
24
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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform