SUMIF Excel equivalent in Omniscope
-
1 Comment
-
Hi,
IMHO, the easiest way is to use SUBSET_SUM([Field],SUBSET([Field_Condition])), where [Field] contains value, you want to sum and [Field_Condition] is the one which holds a condition. For example, the result of SUBSET_SUM([Investment],SUBSET([Year])) will be overall value of investment in each year of you dataset. See http://www.visokio.com/kb/subset-functions.
MichalMichal Charvat | Mindshare | Business Planning | www.mindshare.cz | www.mindshareworld.com
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
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.