Skip to Content
0
Oct 24, 2011 at 09:35 AM

Multiple condition check for a keyfigure at report level

24 Views

Hi Team,

We have to calculate Amount to be spent based on a single KF.

KF range Amount /km

47500km-52499km 1.47Euro/km

52500km-57499km 1.34Euro/km

57500km-62499km 1.22Euro/km

-


-


-


-


-


-


Totally seven Conditions (categories)

Client is expecting this to be achieved at report level as this may change after few years (may be within year).

Any suggestion on how to implement this using query designer (7.0).

Any suggestions will be appreciated.