helenh Member

Comments

  • I got confirmation that for the custom summary number to work, it has to be a value field, not a text field. Here's what I figured out: If you want to use a date alone as a summary number, I figured out a way to trick the system to recognize the date as a value with the following beast mode calc: CONCAT( 'Latest Week…
    in Custom Summary Number Not Cleanly Exportable to Powerpoint ? Comment by helenh October 2019
  • One correction...I see that I can string two fields together, and that will export cleanly, if I don't use html for any additional formatting. One additional quirk: It looks like I can't have a date field as a first or only field in the custom summary number. But, if I string a value field first, together with a date field…
    in Custom Summary Number Not Cleanly Exportable to Powerpoint ? Comment by helenh October 2019
  • Hello @ST_-Superman-_ ! Thanks for providing the detailed solution. Good to know that it can be done and to see the logic used to create this. (And, yes, your assumptions about my data table structure are correct.) I have two questions, if you don't mind me asking. ? While I am familiar with SQL basics, I have not used…
    in How do you extract or select a date from a column header? Comment by helenh October 2019
Default Avatar