texte = Are some of the cells coming back empty and thus collapsing? Add a non-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 as dates:From: [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]To: [Search db=data/directsales.db&rnSALEDATEdata=[DATE_RANGE1a],[DATE_RANGE1b]&SALEDATE type=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 and see if that is getting added to the value. Perhaps the lookups are failing and 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 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/ ------------------------------------------------------------- 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 a non-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 as dates:From: [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]To: [Search db=data/directsales.db&rnSALEDATEdata=[DATE_RANGE1a],[DATE_RANGE1b]&SALEDATE type=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 and see if that is getting added to the value. Perhaps the lookups are failing and 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 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/ ------------------------------------------------------------- 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:
creator code (1997)
Searchable archives gone again??? (2000)
Practice runs ? (1997)
Help needed! (SIMS recommendation) (1998)
[WebDNA] I got v7 running on 64-bit Ubuntu 11.04 ... (2012)
WebCatalog 2.0 b 15 mac (1997)
WebCommerce: Folder organization ? (1997)
[cart] not being interpreted inside [founditems] (1997)
Re1000001: Setting up shop (1997)
Hosts who have upgraded to v5.0? (2003)
Slightly OT: [sendmail] help (2003)
when is failing to [URL]ize values in a comparison risky? (1999)
NT lockup (1998)
Text data with spaces in them... (1997)
[ShowNext] (1997)
WC2f3 (1997)
PSC recommends what date format yr 2000??? (1997)
WebCat2.0 [format thousands .0f] no go (1997)
Press Release hit the NewsWire!!! (1997)
Snake Bites (1997)