Well, I guess never mind...I was able to fill in the missing data by creating a running count field and then create Minimum date field by the new running count.
It works! But I think a lag function in Imporomptu would have been so much easier.
Take Care! ...Donna
In Impromptu 7.3, Is there a function or technique which would fill in a blank field with data from a previous record? I have not been successful with if-then-else statements, the data must come from the previous record.
Any help is much appreciated.... Thanks! Donna
Hi Mick,
I am using Cognos 7.3, but in crosstabs, I've always had issues getting the summary percentages to come out correctly. Usually I get an averages in the summary crosstab.
These are the steps I took in 7.3 to get the right summary percentages:
1. total the whole numbers for Male and...
I am looking for a way to automatically mail an Impromptu report saved as an excel spreadsheet that is password protected.
I already have a macro that that will open Impromptu, attach to the catalog, create an excel spreadsheet and then e-mail it. But now I need to have the excel spreadsheet...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.