I have a scenario where I need to hide the column data based on other column.
If column- daily net is loaded , then cumm diff should be shown .
If daily net is not loaded, the cumm difference shoul be blank ( for date=08 the plan=1000 ; cumm fidd should be null )
I have 2 DP -
1st DP for plan - since it should run for whole period
2nd DP - for Actual -getting the date based on date param ( on run time)
To get the REV i need to pick sum(daily plan)=9000 - cumm diff ( unitl data loaded fro daily net)
In my case - I am also getting the $-1000 added to cumm diff. though it is not dispalyed on reprot but when doing sum( cumm diff) instead of doing (-152.14+(-1621.21)) it is also doing date 8th calcualtion( null or 0 - 1000 =$-1000)
Measure objects
Day vs Plan - Daily Revenue
=[Daily Net Revenue]-[Daily Plan Revenue]
Day vs Plan Rev
=If(If(IsNull([Daily Net Revenue]);0;[Day vs Plan - Daily Revenue])=0 ; “” ; [Day vs Plan - Daily Revenue])
I am hiding data from - day vs plan column as needed and displaying on report. Till the table its fine. But when I am calculating value for projected period 8 1 should get 9000+(-1,773.35)= 7,226.65
Logic- sum( as per plan) = 7000+1000+1000 and
Sum(day vs plan) = 152.14+1621.21
In my case though I hided the day=8 record on report but behind the scrren its calculating
Can you give me step by step how to proceed and where to modify .
where are you getting the 17335.35 to add to the 9000 on day 8? is it from day7? if so then you could use the previous() function to get that value to add to your row in day8
(BOB member since 2006-04-06)
(BOB member since 2004-06-06)
(BOB member since 2011-03-09)
(BOB member since 2012-07-30)