I have an HTML Card where I am performing the below calculation on the card.
If I add Static values (example: pct=80%) While working in the VP I can see the card design, etc.
If I then change the my value to dynamic content (example the below) My HTML Card disappear while in design mode. If I Publish or Run in Test mode it displayed properly without any issue. Only while in the Visual Perspective I am getting this behavior.
Anyone come across this and how do you resolve it. I notice this is happening with certain mathematical calculation functions. ROUND, SUM, COUNT
<div> pct= <<IF ROUND(COUNT DLPAlert WHERE (DLPAlert.Incident IS DEFINED AND DLPAlert.EscalatedDate >= DATE_ADD(CURRENT_DATE, -30)) * 100 / COUNT DLPAlert WHERE (DLPAlert.DateGenerated >= DATE_ADD(CURRENT_DATE, -30)), 0) = ROUND(COUNT DLPAlert WHERE (DLPAlert.Incident IS DEFINED AND DLPAlert.EscalatedDate >= DATE_ADD(CURRENT_DATE, -60) AND DLPAlert.EscalatedDate < DATE_ADD(CURRENT_DATE, -30)) * 100 / COUNT DLPAlert WHERE (DLPAlert.DateGenerated >= DATE_ADD(CURRENT_DATE, -60) AND DLPAlert.DateGenerated < DATE_ADD(CURRENT_DATE, -30)), 0)
THEN SHOW SECTION_START>>
<<IF COUNT DLPAlert WHERE (DLPAlert.DateGenerated >= DATE_ADD(CURRENT_DATE,-30)) > 0 THEN SHOW SECTION_START>>
<<ROUND(COUNT DLPAlert WHERE (DLPAlert.Incident IS DEFINED AND (DLPAlert.EscalatedDate) >= DATE_ADD(CURRENT_DATE,-30)) * 100 / COUNT DLPAlert WHERE (DLPAlert.DateGenerated >= DATE_ADD(CURRENT_DATE,-30)), 0)>>% no change in last 30 days
<<SECTION_END>>
<<IF COUNT DLPAlert WHERE (DLPAlert.DateGenerated >= DATE_ADD(CURRENT_DATE,-30)) = 0 THEN SHOW SECTION_START>>
0% in last 30 days
</div>