Skip to Content
0
Former Member
Oct 13, 2006 at 09:14 AM

How to calculate planned tariff

153 Views

Hello,

Please, help me to sovle an issue!

I have the following report

-


CHAR | Quant | Amnt | Tariff |

-


|

Char_1 | 100 | 200 | 200 |

Char_2 | 150 | 300 | 200 |

Char_3 | | | |

... | ... | ... | ... |

Char_N | 120 | 240 | 200 |

-


KF "Tariff" is calculated KF and equals "Amnt"/"Quant".

But in some cases mentioned values are absent (in case of Char_3). Nevertheless, I've to calculate or just to display this value for Char_3 as well.

Note, that value of tariff is the same for all CHARs.

In other words, I've to get the following report.

-


CHAR | Quant | Amnt | Tariff |

-


|

Char_1 | 100 | 200 | 200 |

Char_2 | 150 | 300 | 200 |

Char_3 | | | 200 |

... | ... | ... | ... |

Char_N | 120 | 240 | 200 |

-


Thanks in advance.