Formula question

[gayathri27]

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.

[Qiu]

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

[ntakeda]

@gayathri27 

I created it with explanations.

Similar questions below.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Alteryx-academy-Practice-exerc...

[gayathri27]

I tried to summarize based on days, total and total saved and was not able to add them to summarize. Any suggestions on how to fix this ?

[ntakeda · Accepted solution]

@gayathri27 

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.

https://help.alteryx.com/20231/designer/data-types

[Raj · Accepted solution]

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