topic Formula to expression in Water Cooler https://community.qlik.com/t5/Water-Cooler/Formula-to-expression/m-p/276162#M299 <HTML><HEAD></HEAD><BODY><P>Awesome, worked like a charm! </P><P></P><P>Thanks a lot mate!</P></BODY></HTML> Mon, 13 Feb 2012 11:25:19 GMT 2012-02-13T11:25:19Z Formula to expression https://community.qlik.com/t5/Water-Cooler/Formula-to-expression/m-p/276160#M297 <HTML><HEAD></HEAD><BODY><P>Hi ya'll!</P><P></P><P>I'm trying to create a simple sales / customer group report but I need to create a formula to the expression since I don't have an total sum field. The formula would would be:</P><P></P><P>sum of (quantity) * (unit price)</P><P></P><P>Any tips on this one? </P><P></P><P>Cheers!</P></BODY></HTML> Mon, 13 Feb 2012 10:58:03 GMT https://community.qlik.com/t5/Water-Cooler/Formula-to-expression/m-p/276160#M297 2012-02-13T10:58:03Z Formula to expression https://community.qlik.com/t5/Water-Cooler/Formula-to-expression/m-p/276161#M298 <HTML><HEAD></HEAD><BODY><P> Hi,</P><P></P><P>In your load script, just write a line like</P><P></P><P>quantity * [unit price] as TotalPrice;</P><P></P><P>Regards,</P><P>sebablum</P></BODY></HTML> Mon, 13 Feb 2012 11:01:42 GMT https://community.qlik.com/t5/Water-Cooler/Formula-to-expression/m-p/276161#M298 2012-02-13T11:01:42Z Formula to expression https://community.qlik.com/t5/Water-Cooler/Formula-to-expression/m-p/276162#M299 <HTML><HEAD></HEAD><BODY><P>Awesome, worked like a charm! </P><P></P><P>Thanks a lot mate!</P></BODY></HTML> Mon, 13 Feb 2012 11:25:19 GMT https://community.qlik.com/t5/Water-Cooler/Formula-to-expression/m-p/276162#M299 2012-02-13T11:25:19Z Formula to expression https://community.qlik.com/t5/Water-Cooler/Formula-to-expression/m-p/276163#M300 <HTML><HEAD></HEAD><BODY><P>Glat this helped! Thanks Anttiturunen for also marking the answer are correct. This helps users accumulate points in QlikCommunity and also helps them build their online presence and expertise in QlikCommunity. Have a great day!</P></BODY></HTML> Mon, 13 Feb 2012 19:00:28 GMT https://community.qlik.com/t5/Water-Cooler/Formula-to-expression/m-p/276163#M300 Anonymous 2012-02-13T19:00:28Z