> | > | | 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/ > ------------------------------------------------------------- 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:
It seems that the problem has been fixed by making [Format thousands] into [Format thousands .2f]. It is now working consistently. But the problems seems to have been caused by bad math!!!For example, here's a few of the variables.2002_SALES_2=125360.1 SAP_SALES_2=123000 but [math][SAP_SALES_2]-[2002_SALES_2][/math]= -2360.10000000001Where did all the decimals places come from?!?! It terms of a [math] calculation, this is pretty bloody easy. I could probably come closer to that in my head! (well at least in terms of decimal places...)What's going on here?!?! And now i find when you add the [Format thousands .2f] to a value, it can't display the 'minus' of the negative value.....Any ideas on this bad math?Regards, Tim> From: Gary Krockover > Reply-To: (WebCatalog Talk) > Date: Wed, 4 Dec 2002 17:24:13 -0600 > To: (WebCatalog Talk) > Subject: Re: Strange non-display problem > > 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/ > ------------------------------------------------------------- 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:
Trouble with formula.db (1997)
WebDNA-Talk Digests (1997)
Authenticate (1997)
[TaxableTotal] - not working with AOL and IE (1997)
Great product and great job ! (1997)
Force leading zeros (1998)
Setting a null value for reply to address using sendmail... (2001)
Generating Report Totals (1997)
Purchase command error problem (1997)
Undocumented changes create problems in webcat 4 ... (2000)
serial number generation (1997)
WebMerchant and PCAuthorize (1998)
Price Change (2000)
do you have a webcatalog tool you want to sell? (1999)
Targeted Redirect (1999)
Links and Carriage Returns, Oh my! (2000)
GoLive CyberStudio 1.0.1 (1997)
Printing from Web pages (1998)
Question About XML Style Syntax (2000)
WebDNA Solutions ... sorry! (1997)