Forum Discussion
PhineasT
Helper I
Helper IReplace Blank Values and Empty Visuals
I want to display a '0' in the top box (circle that reads "Blank"), if the is no associated data to calculate and the phrase 'No data available' in the low box (circle). Is this possible? ...
tamerj1
Community Champion
Community ChampionHi PhineasT
Assuming activities completed is a measure of decimal or integer data type then try
Assuming activities =
"Original aggregation formula" + 0
PhineasTHelper I
Helper IIt is not a measure of decimal, it is a text field on which I need to apply a Count condition that returns the total number of 'Activities'.
I believe the calculationis being impacted by the Project Name dropdown on the right edge. The Activities count changes whent he dropdown changes, and where there is no 'Activity' (Blank) appears.
I think I may need two control, for I need one static control that shows ALL 'Activities' and I need to know how many 'Activities' based on the choice in the dropdown.