Gareth Horton
July 12th, 2002, 01:03 PM
Brian Hammer wrote:
> In my Monarch Table I have a calculated field. This field is based on an "if" function call.
> The purpose is to extract the date from the report, but the problem is that not all the detail lines
> have a date associated with them. Most of the details have a date, but some don't. For example,
> we sell a kit (detail line containing a date), but that kit consists of a series of each item contained
> in the kit (detail line not containing a date). The report assumes that the date is the same as the kit.
> The purpose of the if statement is to see if there was a date provided or not. If there is I want to fill
> my claculated field with the date, if not I want it to use the date from the last detail that had one.
> This should work similarly to the "use previous row value for blanks" option that is present for
> non calculated fields. The reason I can't use that is because the lines that don't contain a date
> do contain a phrase saying something like "Part of Kit" instead of just being blank. Any help would
> be greatly appreciated, thanks a ton!
>
> Brian
Brian,
I could be wrong (it's been known to happen on rare occasions), but it sounds like you need to format the column you are pulling the date into to a date format (you must currently have it as a character format to allow the "Part of Kit" to show up). That way if Monarch reads information that does not fit as a date it will leave the space blank. Of course it is difficult to try to figure out a work-around for a monarch problem without more detailed information about your model and the way your report is set up. But hopefully this will help.
Dale
Kenny Cheng wrote:
> Brian,
> From the way you describe your report, it should look something like this?
>
> mm/dd/yyyy detail
> Part of Kit detail
> Part of Kit detail
>
> mm/dd/yyyy detail
> Part of Kit detail
> ...
> ...
> etc.
>
> If that's the case, you can capture the Date in an Append template. That way the date will append to the details that's part of the kit. If you have any question, feel free to contact out technical support department @ 978-441-2200.
>
>
Thanks so very much. Boy that's such an obvious solution, and appears to be exactly what I wanted it to do. I just had my head thinking that an append template couldn't be on the same line as a detail for some reason smile.gif I just started learning Monarch in May and I'm the only one in our company who has used it at all really, so this was the only place I could go for help. Thanks for your help, its greatly appreciated.
> In my Monarch Table I have a calculated field. This field is based on an "if" function call.
> The purpose is to extract the date from the report, but the problem is that not all the detail lines
> have a date associated with them. Most of the details have a date, but some don't. For example,
> we sell a kit (detail line containing a date), but that kit consists of a series of each item contained
> in the kit (detail line not containing a date). The report assumes that the date is the same as the kit.
> The purpose of the if statement is to see if there was a date provided or not. If there is I want to fill
> my claculated field with the date, if not I want it to use the date from the last detail that had one.
> This should work similarly to the "use previous row value for blanks" option that is present for
> non calculated fields. The reason I can't use that is because the lines that don't contain a date
> do contain a phrase saying something like "Part of Kit" instead of just being blank. Any help would
> be greatly appreciated, thanks a ton!
>
> Brian
Brian,
I could be wrong (it's been known to happen on rare occasions), but it sounds like you need to format the column you are pulling the date into to a date format (you must currently have it as a character format to allow the "Part of Kit" to show up). That way if Monarch reads information that does not fit as a date it will leave the space blank. Of course it is difficult to try to figure out a work-around for a monarch problem without more detailed information about your model and the way your report is set up. But hopefully this will help.
Dale
Kenny Cheng wrote:
> Brian,
> From the way you describe your report, it should look something like this?
>
> mm/dd/yyyy detail
> Part of Kit detail
> Part of Kit detail
>
> mm/dd/yyyy detail
> Part of Kit detail
> ...
> ...
> etc.
>
> If that's the case, you can capture the Date in an Append template. That way the date will append to the details that's part of the kit. If you have any question, feel free to contact out technical support department @ 978-441-2200.
>
>
Thanks so very much. Boy that's such an obvious solution, and appears to be exactly what I wanted it to do. I just had my head thinking that an append template couldn't be on the same line as a detail for some reason smile.gif I just started learning Monarch in May and I'm the only one in our company who has used it at all really, so this was the only place I could go for help. Thanks for your help, its greatly appreciated.