Skip to Content
0
Former Member
Jan 15, 2008 at 05:34 AM

How to create restrictions on K.F's w.r.t amount values

25 Views

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!!