Hi All,
I need to create a formatted report, below is the format:
Report format Explanation:
1st row: Header; 2nd & 3rd rows are values & on right side, there is Over 1 million & Less than 1miilion which are the formula/restrictions I need to include in the report.
(Investors) (Grants) (Cost-1st yr) (Total cost)
___6_______7_____$4,000,000___ $8,000,000_______________________Over 1 million
___2_______2_____$450,000)_____$900,000) _______________________ Less than 1miilion
As seen above, 'Investors' & 'Grants' are Counts of Chars which I am able to derive successfully. "Cost for current yr" & "Total cost for all years" are K.F's. Now with respect to these K.F values I need to display the result as above. I need to create some formula for K.F's in Rows, one for Amounts which are "over 1 million" & other for Amounts which are "less than a million". I am not sure how to do this, I am creating this query in BI 7.0.
can anyone please advice?
Thanks a lot!!