> | > | | 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:
[searh] or [shownext]problem (1998)
Secure Server not remembering discounts (1998)
WebCat & WebTen (1997)
DON'T use old cart file! (1997)
Who is doing sign-ups (1998)
[delete] problem (1997)
More than one db with the same namn (was: WC2f3) (1997)
Include (1998)
emailer (1997)
[protect admin] (1997)
Secure Server (1997)
WebCommerce: Folder organization ? (1997)
Any WebCatters going to CeBit in Hanover, Germany? (2000)
[OT] Disable/enable field (2003)
Re:Emailer problem....still (1997)
syntax for contains a word (2002)
synching databases on multiple servers (1997)
Orders and notification (1998)
More questions about serial number dishing (1997)
Random/Odd/Even Listings (2005)