# Thread: Converting Calculated Formulas

1. Registered User
Join Date
Jul 2009
Posts
2

## Unanswered: Converting Calculated Formulas

Recently I have been trying to convert a Paradox for DOS report to Windows by creating the design by hand but copying the calculations into the new fields.

The report simply tallies the number of records based on different conditions and displays the totals in a set of columns. I haven't had issues creating the layout, but the Windows version of Paradox will not accept the calculation formulas so I wanted to know if there was a guide I could use to figure out how to switch the formulas over.

There isn't really any programming logic involved. The formulas are simply count commands with iif statements for the different criteria.

Thank you in advance for any assistance.

2. Registered User
Join Date
Dec 2007
Posts
374
please show the exact code you are using, or we can only guess..

3. Registered User
Join Date
Jul 2009
Posts
2
Hello Steve,

Thank you for your prompt response.

Below is the original code, and below that is the new code I've been trying to use (aside from the original).

COUNT(IIF([W1]="LC",IIF(ISBLANK([W2]),IIF(ISBLANK([W3]),IIF(ISBLANK([W4]),1,""),""),""),""))
NUMVAL(COUNT(IIF([W1]="LC",IIF([Commute]="C",IIF(ISBLANK([W2]),IIF(ISBLANK([W3]),IIF(ISBLANK([W4]),1,""),""),""),""),"")))
NUMVAL(COUNT(IIF([W1]="LC",IIF([Overnight]="O",IIF(ISBLANK([W2]),IIF(ISBLANK([W3]),IIF(ISBLANK([W4]),1,""),""),""),""),"")))
NUMVAL(COUNT(IIF([W1]="LC",IIF(ISBLANK([W2]),IIF([Overnight]="B",IIF(ISBLANK([W3]),IIF(ISBLANK([W4]),1,""),""),""),""),"")))
NUMVAL(COUNT(IIF([W1]="LC",IIF([Single/Double]="S",IIF(ISBLANK([W2]),IIF(ISBLANK([W3]),IIF(ISBLANK([W4]),1,""),""),""),""),"")))
NUMVAL(COUNT(IIF([W1]="LC",IIF([Single/Double]="D",IIF(ISBLANK([W2]),IIF(ISBLANK([W3]),IIF(ISBLANK([W4]),1,""),""),""),""),"")))

New code:

COUNT(IIF([ASHE5-09.W1]="LC",IIF(isBlank([ASHE5-09.W2]),IIF(isBlank([ASHE5-09.W3]),IIF(isBlank([ASHE5-09.W4]),1,""),""),""),""))

I also tried more variations such as quotes around the table and others but nothing has worked. I did manage to create queries however, but I don't think importing a query for every field (literally over a hundred) is practical on the technical side of things.

4. Registered User
Join Date
Dec 2007
Posts
374
you haven't posted the exact error messages, and I don't have PdoxWIN loaded on the machine I'm at, but the ordinary "this is a field name" logic in PdoxWIN is not the same as PdoxDOS..

PdoxDOS - [table->field]
PdoxWIN - table."field"

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•