I am working on solving a problem and stuck on how to derive the below. Any tips on how to get this subtotal would be appreciated.
calculate the subtotal for each line item (discount is per unit and shipping is a flat cost).find the Total cost for each order, the "Total Saved" for each order, and the number of days it took to pay the report in full.
Solved! Go to Solution.
@gayathri27
Can you at least give a try and show in your work progress even?
I think it will be better you tried to solve it first then realize the real diffculty you are facing. 😁
I created it with explanations.
Similar questions below.
In the Formula Tool, is "No. of Days" specified as a numeric data type (e.g., Int32)?
If you have chosen a character data type (e.g. string), SUM cannot be used.
@gayathri27 just check the data types.
For performing any type of Mathematical calculation we need to set the data type to numeric form.
hope this helps.