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