Forum Discussion

hamzashafiq's avatar
hamzashafiq
Icon for Kudo Collector rankKudo Collector
4 years ago

Formula Help

Hi Folks,   I've similar data below with 4 cases. Each case has the required Usage difference, Sum Cost and cost/hour numbers below. I've calculated the usage and cost for three cases with the cond...
Need Help
hamzashafiq's avatar
hamzashafiq
Icon for Kudo Collector rankKudo Collector
4 years ago

Hi v-henryk-mstf thanks for your reply, however it look like this formula will also include total cost for 2nd and 3rd case. We don't want to include the cost when the 0 hours came in the beginning or in the end. For those cases we won't include the total cost. For the 4th case when 0 appears in between so we will include the cost. I hope you understand.

v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
4 years ago

Hi hamzashafiq ,

 

In order to be able to achieve exactly what you want, can you provide screenshots of the desired results and describe them?


Looking forward to your reply.


Best Regards,
Henry

 

  • hamzashafiq's avatar
    hamzashafiq
    Icon for Kudo Collector rankKudo Collector
    4 years ago

    Hi v-henryk-mstf on the table above in my first message, you can see Usage Difference and Cost Sum is the desired output we need from the bolded values in the column. The Usage difference is the difference of the bolded values above and total cost is the sum of the bolded one. I have bolded the values according to the case. I hope it helps.