
Contributor
2020-09-07
05:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
RangeSum and above
Hey Guys,
So I'm using RangeSum and above functions to calculate the sum of data for current year till current month. But i also have to show the data for last year upto current month in a Kpi. I'm using below expression but not sure how to calculate data of last year till current month. The expression is giving data upto whole year.
Exp:
Rangesum(above(sum({<conditions>}if((Year='Preyearvariable'),data)),0,Rowno()))
Any suggestion?
400 Views
0 Replies
