Skip to Content
author's profile photo Former Member
Former Member

How to calculate planned tariff

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2006 at 09:25 AM

    Hi,

    You have tariff = Amount /Quan. Well, if you do not have these values you still should show the tariff. Do you mean to say that tariff is same (200) everytime?

    If it is same everytime, you can hide the existing Tariff column and in a new formula you can write the formula like this.

    tariff equal to 0, then 200 else tariff.

    (tariff = 0)*200+tariff.

    This should solve your problem. else think of cell dfinitions if you have 2 structures in place.

    Hope this helps you...

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      ... and I'd like to add some information regarding this issue.

      We have the following report

      -


      CHAR | QuantP | AmntP | Tariff | QuantF | AmntF |

      -


      |

      Char_1 | 100 | 200 | 200 | 120 | 240 |

      Char_2 | 150 | 300 | 200 | 130 | 260 |

      Char_3 | | | | 150 | 300 |

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

      Char_N | 120 | 240 | 200 | 210 | 420 |

      -


      I have to calculate AmntF using planned tariff, which is calculated as AmntP/QuantP.

      Planned KFs for Char_3 are absent.

      Note, that calculated tariff is the same for all CHARs.

      I tried to calculate this tariff using the following fromula:

      SUMCT AmntP / SUMCT QuantP, but as result got 'X'.

      Do you have any ideas to solve this issue?

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.