texte = Are some of the cells coming back empty and thus collapsing? Add anon-breaking space to all the cells: That will at least keep the cells from collapsing.And not sure, but maybe the other dates in this search need to be id'd asdates:From:[Searchdb=data/directsales.db&rnSALEDATEdata=[DATE_RANGE1a],[DATE_RANGE1b]&SALEDATEtype=date&saledatewbrk=,][text show=F][START_YEAR]_SALES_1=[Sum field=sale_total][/text][/Search]To:[Searchdb=data/directsales.db&rnSALEDATEdata=[DATE_RANGE1a],[DATE_RANGE1b]&SALEDATEtype=date&DATE_RANGE1atype=date&DATE_RANGE1btype=date&saledatewbrk=,][text show=F][START_YEAR]_SALES_1=[Sum field=sale_total][/text][/Search]On your lookups, substitue a high value, like 9999 for TextIfNotFound andsee if that is getting added to the value. Perhaps the lookups are failingand the math isn't working because the 'not found' is a text string.GK| 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 arefilled| 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]|| [TEXTshow=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/-------------------------------------------------------------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:
Are some of the cells coming back empty and thus collapsing? Add anon-breaking space to all the cells: That will at least keep the cells from collapsing.And not sure, but maybe the other dates in this search need to be id'd asdates:From:[Searchdb=data/directsales.db&rnSALEDATEdata=[DATE_RANGE1a],[DATE_RANGE1b]&SALEDATEtype=date&saledatewbrk=,][text show=F][START_YEAR]_SALES_1=[Sum field=sale_total][/text][/Search]To:[Searchdb=data/directsales.db&rnSALEDATEdata=[DATE_RANGE1a],[DATE_RANGE1b]&SALEDATEtype=date&DATE_RANGE1atype=date&DATE_RANGE1btype=date&saledatewbrk=,][text show=F][START_YEAR]_SALES_1=[Sum field=sale_total][/text][/Search]On your lookups, substitue a high value, like 9999 for TextIfNotFound andsee if that is getting added to the value. Perhaps the lookups are failingand the math isn't working because the 'not found' is a text string.GK| 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 arefilled| 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]|| [TEXTshow=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/-------------------------------------------------------------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/
Gary Krockover
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:
Searching multiple fields (1997)
Price problem (1997)
searching for items that begin with a number (2004)
Anyone on OSX updated to iTools 5.018? (2000)
Kaaaaahhhhhhhnnnnnnn! (1997)
Multiple hideif's or if (2007)
admin login problems - something else now (2000)
Caching pages...again (2001)
[subtotal] and others (1997)
Variable in a variable (2002)
Database changes (1998)
WebCatalog Features (1997)
Dealing with return characters (2004)
WebTen and WebCat (1997)
Garbage files created (2000)
Location of Browser Info.txt file (1997)
CAPTCHA system in webDNA (2005)
with Link i need to (1997)
Single Link browsing (1997)
Search Question (2000)