Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am trying to figure out an expression for a dimension for a table.
This is my table and the current expression for the Adjusted Encounters dimension
IF([Service Date] <= Today()
, 'Actual through ' & date(today(),'MM/DD')
,'Forecast through ' & date(floor(monthend(Today())), 'MM/DD')
)
I want the Actual numbers to be everything up to and including 03/22/17, and the Forecast to be everything up to and including 03/31/17. Right now it is putting the counts into one or the other. For example, the Actual for Forecast should be 4,620,281, instead of the 1,936,560. Is it best to try to do that in the dimension, or in the expression of the measures?
You should do that in the measure;
What is the measure you're using?
is this the values showing in the table dynamic , I mean this should vary by selections
The expression for Actual is SUM({<[Fact Type]={'P-VP Daily AGG'}>}[Flash Encounters MTD])
and the expression for Budget is SUM({<[Fact Type]={'P-VP Daily AGG'}>}[Budget Encounters MTD]).
Can you please attach a test application containing this table so I can work on?
I think I can do it.
Thanks,
Omar,
Try rangesum(above( SUM({<[Fact Type]={'P-VP Daily AGG'}>}[Flash Encounters MTD]),0,rowno())
Try this:
If([Service Date] <= Today(), Sum({<[Fact Type]={'P-VP Daily AGG'}>} [Flash Encounters MTD]), Sum(TOTAL {<[Fact Type]={'P-VP Daily AGG'}>} [Flash Encounters MTD]))