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:
sum of (quantity) * (unit price)
Any tips on this one?
In your load script, just write a line like
quantity * [unit price] as TotalPrice;
Awesome, worked like a charm!
Thanks a lot mate!
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!
Retrieving data ...