Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Been stuck on this issue for some time now. Trying to use the following calculated dimension and getting different results in development vs. web-based access. Need to place folks into various buckets based on blood pressure tests:
In the development environment, I am getting the people who should be in the no results bucket forced into a column with a null heading. On the web-based side, all of these people are correctly placed, with no one showing up as null in the calculated dimension. They both use the same data, dimensions, and expressions in the object. Any thoughts as to why this might be happening?
=if(isnull(Diastolic) or isnull(Systolic),dual('No Results',4),
if(Diastolic<80 and Systolic<120,Dual('Normal < 120/80',1),
if(Diastolic>89 or Systolic>139,Dual('Hypertension >=140/90',3),Dual('Prehypertension 120/80 - 139/89',2))))
You could probably just avoid using a calculated dimension.
You could probably just avoid using a calculated dimension.
as simple as that sounds, it worked. i still am confused as to why the results would be different in development vs. server.