texte = Hi everyone, I'm getting a very strange behaviour in a financial reporting table only 7 columns wide, and 12 rows high (one row for each month). TD cells are filled with a variety of information - a search, two lookups, and calculations on those values. The table displays something different every time.... sometimes there is nothing in the cell, sometimes the correct value, and sometimes the WRONG value. But when I do a list variables at the bottom of the page, ALL variables have the correct value!!I initially had the 12 month rows working as a loop, but the results were even worse! Having manually coded the 12 months, it's better but still inconsistent. The loop solution should've worked properly, and so should this.The values that seems to drop out most often are [SAP_SALES_1] and [BUDGET_SALES_1]. But to prove I'm not mad, the last two columns ALWAYS work, even though they use these two fields for the calculations....Does anyone have any ideas? All help greatly appreciated as always. I've copied relevant code below.Regards, Tim -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837 [TEXT show=f]START_YEAR=2002[/TEXT]
| Month Ending | COMS Sales | SAP Sales | Sys Var | Budget | Budget Var |
[Search db=data/directsales.db&rnSALEDATEdata=[DATE_RANGE1a],[DATE_RANGE1b]&SALEDATE type=date&saledatewbrk=,] [text show=F][START_YEAR]_SALES_1=[Sum field=sale_total][/text] [/Search][TEXT show=F]SAP_SALES_1=[LOOKUP db=data/SAP_sales.db&value=[START_YEAR]_1&lookInField=SKU&returnField=SAP_SA LES¬Found=TextIfNotFound][/TEXT][TEXT show=F]SYS_VAR_1=[math][SAP_SALES_1]-[interpret][[START_YEAR]_SALES_1][/inte rpret][/math][/TEXT][TEXT show=F]BUDGET_SALES_1=[LOOKUP db=data/SAP_sales.db&value=[START_YEAR]_1&lookInField=SKU&returnField=BUDGET _SALES¬Found=TextIfNotFound][/TEXT][TEXT show=F]BUDGET_VAR_1=[math][SAP_SALES_1]-[BUDGET_SALES_1][/math][/TEXT][TEXT show=F]VAR_PERCENT_1=[math][BUDGET_VAR_1]/[BUDGET_SALES_1]*100[/math][/TEXT] | [DATE_RANGE1b] | [Format thousands .2f][interpret][[START_YEAR]_SALES_1][/interpret][/format] | [Format thousands][SAP_SALES_1][/format] | [Format thousands][SYS_VAR_1][/format] | [Format thousands][BUDGET_SALES_1][/format] | [Format thousands][BUDGET_VAR_1][/format] | [Format .2f][VAR_PERCENT_1][/format]% |
Regards, Tim -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hi everyone, I'm getting a very strange behaviour in a financial reporting table only 7 columns wide, and 12 rows high (one row for each month). TD cells are filled with a variety of information - a search, two lookups, and calculations on those values. The table displays something different every time.... sometimes there is nothing in the cell, sometimes the correct value, and sometimes the WRONG value. But when I do a list variables at the bottom of the page, ALL variables have the correct value!!I initially had the 12 month rows working as a loop, but the results were even worse! Having manually coded the 12 months, it's better but still inconsistent. The loop solution should've worked properly, and so should this.The values that seems to drop out most often are [SAP_SALES_1] and [BUDGET_SALES_1]. But to prove I'm not mad, the last two columns ALWAYS work, even though they use these two fields for the calculations....Does anyone have any ideas? All help greatly appreciated as always. I've copied relevant code below.Regards, Tim -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837 [TEXT show=f]START_YEAR=2002[/TEXT] | Month Ending | COMS Sales | SAP Sales | Sys Var | Budget | Budget Var |
[Search db=data/directsales.db&rnSALEDATEdata=[DATE_RANGE1a],[DATE_RANGE1b]&SALEDATE type=date&saledatewbrk=,] [text show=F][START_YEAR]_SALES_1=[Sum field=sale_total][/text] [/Search][TEXT show=F]SAP_SALES_1=[LOOKUP db=data/SAP_sales.db&value=[START_YEAR]_1&lookInField=SKU&returnField=SAP_SA LES¬Found=TextIfNotFound][/TEXT][TEXT show=F]SYS_VAR_1=[math][SAP_SALES_1]-[interpret][[START_YEAR]_SALES_1][/inte rpret][/math][/TEXT][TEXT show=F]BUDGET_SALES_1=[LOOKUP db=data/SAP_sales.db&value=[START_YEAR]_1&lookInField=SKU&returnField=BUDGET _SALES¬Found=TextIfNotFound][/TEXT][TEXT show=F]BUDGET_VAR_1=[math][SAP_SALES_1]-[BUDGET_SALES_1][/math][/TEXT][TEXT show=F]VAR_PERCENT_1=[math][BUDGET_VAR_1]/[BUDGET_SALES_1]*100[/math][/TEXT] | [DATE_RANGE1b] | [Format thousands .2f][interpret][[START_YEAR]_SALES_1][/interpret][/format] | [Format thousands][SAP_SALES_1][/format] | [Format thousands][SYS_VAR_1][/format] | [Format thousands][BUDGET_SALES_1][/format] | [Format thousands][BUDGET_VAR_1][/format] | [Format .2f][VAR_PERCENT_1][/format]% |
Regards, Tim -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Tim Robinson
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Country & Ship-to address & other fields ? (1997)
WebCat2 - [include] tags (1997)
[format 40s]text[/format] doesn't work (1997)
Beta 18 (1997)
Editing two databases in one form using [replace]? (1998)
Share cost of training videos! (1998)
selectively replacing records within a [founditems] (2000)
Sort Order on a page search (1997)
CommandSecurity? (1997)
emailer w/F2 (1997)
Email password -- was Classified Ads 4 Sale (1998)
Is this possible, WebCat2.0 and checkboxes (1997)
[WebDNA] [table] and COMMA in a Field (2015)
The evolved Server Configuration Queston (2000)
FlushDatabase Suggestion (1998)
Credit card types (1997)
insecure client not shown (1998)
[OT] Democratic Code (2002)
Moment of Thanks (1997)
[MOVEFILE] question (2004)