Formulae: Help with syntax?
-
Hi - I'm an beginner in Omniscope. I'm trying to create a report. My report is about sales data. My graph is about salesamount by country. My formula for [salesamount] is:
"
=SUM(([Unitprice]*[Quantity])*(1-[Discount]))
[Unitprice],[Quantity] and [Discount] are my fields....
Is it possible to create formula like this? If can please guide? Thanks. -
1 Comment
-
You can solve this in the DataExplorer - Table View, by adding a formula field that will calculate the product for each record:
[Formula Field]= [Unitprice]*[Quantity]*([Discount]-1)
You can then use Grouping or Aggregation to generate total, as well as category subtotals. Tick 'Show overall summary row'.
If you wish to design a new table in the Content View, following formula will sum the values in the Formula Field and return a single value:
SUBSET_SUM([Formula field])
You can also use the above formulas when creating calculated fields in the DataManager space.
Please note that formulas created in DataManager will be imported into Omniscope as static values.
Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
Tagged
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.