Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to show the sparklines based on two date fields. I have an open date field and production date field. I also have a field called deposits_balance_amt. Essentially I would like to show a running sum of the data from my min production date to today IF my open date has been within the this year. For some reason when I use set analysis or if statements my sparklines show a 0 value. Any help would be greatly appreciated.
What are the Expressions you're using?
Post some sample data, to get an idea on issue.
First try the expression and dimension you use for sparklines in a standalone table to see if it is working.
so the expression works and i get sparklines that show the sum for the day. However, I need to see a cumulative summation in the sparklines.
Thanks
May be add Cumulative sum like this:
RangeSum(Above(TOTAL Sum(Amount), 0, ColumnNo(TOTAL)))
For those that asked this is my set analysis formula for the sparklines:
sum({1<open_dt = {">$(=min([Production Date]))"}>}Deposits_curr_bal_amt)
Excuse me ma'am can you please give more information