WAS Strange non-display problem, now BAD MATH

This WebDNA talk-list message is from

2002

It keeps the original formatting. numero = 45976
interpreted = N
texte = It seems that the problem has been fixed by making [Format thousands] into[Format thousands .2f]. It is now working consistently. But the problemsseems to have been caused by bad math!!!For example, here's a few of the variables.2002_SALES_2=125360.1SAP_SALES_2=123000but [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 tothat 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]> |> | > | > | > | > | > | > | > | > | > |> | [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]> |> | > | > | > | > | > | > | > | > | > |> |> | 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:

Month Ending	COMS Sales	SAP Sales	Sys Var	Budget	Budget Var
[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]%

Re: WAS Strange non-display problem, now BAD MATH (Tim Robinson 2002)
Re: WAS Strange non-display problem, now BAD MATH (Larry Goodhew 2002)
Re: WAS Strange non-display problem, now BAD MATH (Tim Robinson 2002)
Re: WAS Strange non-display problem, now BAD MATH (Larry Goodhew 2002)
WAS Strange non-display problem, now BAD MATH (Tim Robinson 2002)

It seems that the problem has been fixed by making [Format thousands] into[Format thousands .2f]. It is now working consistently. But the problemsseems to have been caused by bad math!!!For example, here's a few of the variables.2002_SALES_2=125360.1SAP_SALES_2=123000but [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 tothat 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]> |> | > | > | > | > | > | > | > | > | > |> | [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]> |> | > | > | > | > | > | > | > | > | > |> |> | 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!

WAS Strange non-display problem, now BAD MATH

2002

Top Articles:

Related Readings: