-
Help with filtering Null Value
Hi, I am creating a beast mode case when statement. sum(case when `lgract` = '4001' then `crdamt`end ) - sum(case when `lgract` = '4001' then `dbtamt`end ) What I need help with is sometimes crdamt returns a null value. I would like it to revert to a 0 value in this case. I believe I need to use NULLIF(crdamt, 0) However I…
-
Table Card too Large for Publication
I have a slideshow created within DOMO's publication feature. The slideshow consists of several table cards that I would like to display on overhead monitors in my office. A couple of these tables are slightly too large and some of the rows are not being shown on the screen. Is there some feature or work around? Maybe an…
-
Help Creating New Column From Summing Another Column
Hello, What I am trying to do seems pretty straighforward, but due to my lack of knowledge/experience, I am having a hard time getting it. I have card that displays the total contract value of of projects assigned to a particular project manager/employee for a given time period. My goal is to create a new column that…
