Skip to content
DataMiner DoJo

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search in posts
Search in pages
Search in posts
Search in pages
Log in
Menu
  • Blog
  • Questions
  • Learning
    • Courses
    • Certification
      • DataMiner Operator
      • DataMiner Administrator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
    • Video Library
    • Books We Like
    • Third-party Courses
    • DevOps Enablement Services
    • Quizzes
  • RESOURCES
  • Agile
    • Agile Webspace
    • Everything Agile
      • The Agile Manifesto
      • Best Practices
      • Retro Recipes
    • Methodologies
      • The Scrum Framework
      • Kanban
      • Extreme Programming
    • Roles
      • The Product Owner
      • The Agile Coach
      • The Quality & UX Coach (QX)
  • Expert Hubs
    • DataMiner DevOps Professional Program
    • DataMiner
      • DataMiner Releases & Updates
      • System Architecture
      • Integration Studio
      • Visual Overview
      • Security
    • Technologies
      • CI/CD
      • Converged Interconnect Networks
      • DOCSIS 3.1 / DAA
      • Elasticsearch
      • Kubernetes
      • Telemetry / Flow Monitoring
      • PTP
      • SDN / ST2110 / NMOS
    • Business
      • Software Business models
      • Perpetual Use or Usage-based Services
  • Discover
    • Markets
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • Solutions
    • Use Case Library
    • DataMiner Dashboards
    • DataMiner Downloads
    • DataMiner Modules
      • Core features
      • SRM features
    • DataMiner Apps
    • Professional Services
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • Pricing
  • More
    • Feature Suggestions
    • Online DataMiner Systems
    • Leaderboard
    • Swag Shop
    • Contact
      • General Inquiries
      • DataMiner DevOps Support
      • Commercial Requests
    • Global Feedback Survey
    • Verify a certificate
  • >> Go to dataminer.services

Subtract data in Visio

Solved177 views5th July 2023subtract visio properties
2
Thomaz Malmberg [DevOps Advocate]162 29th May 2023 2 Comments

Hi again,

Ill try again to see if someone could help me with this because I´m totally stucke. I had already an question about this issue with lots of answers but they are not working in my case so I try again. This is the old question: https://community.dataminer.services/questions/edit/?id=107088&__nonce=bd0ea84469

An ordinary Subtract is working with just numbers but not when I´m using Param also. Is Subtract only working in format: HH:MM:SS ?

This is the example that I have tried with bad results.

// Thomaz

Marieke Goethals [SLC] [DevOps Enabler] Selected answer as best 5th July 2023
Toon Casteele [SLC] [DevOps Enabler] commented 30th May 2023

The best way to debug these kinds of issues is always to work from the inside to the outside. Put your param placeholders separately in a shape text and check the result. Are the numbers what you expect them to be? What if you subtract the results statically? Only then can we look to combine and/or think whether this is a software issue or not. Hope that helps.

Thomaz Malmberg [DevOps Advocate] commented 30th May 2023

Hi,
I have them separated and the results from the parameter is correct.
[Param:120501/2735,6453,TL-DD-ENC] = 180
[Param:120501/2735,6454,TL-DD-ENC] = 101

Then I will subtract 6454 from 6453 and get the results and that is not working.
I have also now tried the sum that Jarno proposal and that was working.
[Sum:[Param:120501/2735,6453,TL-DD-ENC], -[Param:120501/2735,6454,TL-DD-ENC]]

So for me so is the sum working but not subtract

Thanks for your help

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
0
Jarno Lernou [SLC] [DevOps Enabler]2.41K Posted 29th May 2023 4 Comments

Hi Thomaz,

Nice to meet you!

From my experience (and also from the DM Docs [Subtract:...]), I think the placeholder is only to be used with date-time and timespan. I'd let it up to the software team to either confirm or deny this statement.

I would suggest using the [Sum:X,Y,Z] placeholder. You can simply add a minus (-) sign before your param placeholder.

Example: [Sum:[param:123/45,67], -[param:123/45,89]]

Kind Regards,
Jarno

Marieke Goethals [SLC] [DevOps Enabler] Selected answer as best 5th July 2023
Toon Casteele [SLC] [DevOps Enabler] commented 30th May 2023

Subtract should work perfectly fine with numbers FYI.

Thomaz Malmberg [DevOps Advocate] commented 30th May 2023

Hi Jarno,

Thanks for your help and the sum example you mentioned was working perfect.

Do you know how I now can get the sum of the results that I has got?
I want to have these results into a sum of all 3.
[Sum:[Param:120501/2735,6453,TL-DD-DEC], -[Param:120501/2735,6454,TL-DD-DEC]]
– (Sub)
[Sum:[Param:120501/3877,6453,TL-DD-DEC], -[Param:120501/3877,6454,TL-DD-DEC]]
– (Sub)
[Sum:[Param:120501/2742,6453,TL-DD-DEC], -[Param:120501/2742,6454,TL-DD-DEC]]
= (Sum)

Br,
Thomaz

Sebastiaan Dumoulein [SLC] [DevOps Enabler] commented 1st June 2023

This can be achieved by nesting these in a sum placeholder again:
[Sum:[Sum:[Param:120501/2735,6453,TL-DD-DEC], -[Param:120501/2735,6454,TL-DD-DEC]],[Sum:[Param:120501/3877,6453,TL-DD-DEC], -[Param:120501/3877,6454,TL-DD-DEC]], [Sum:[Param:120501/2742,6453,TL-DD-DEC], -[Param:120501/2742,6454,TL-DD-DEC]]]

Sebastiaan Dumoulein [SLC] [DevOps Enabler] commented 10th June 2023

The subtract placeholder was not yet working with numbers. Support for this has been added in 10.3.8 with RN36636. Thanks for using the community Thomaz!

Please login to be able to comment or post an answer.

My Dojo Points

0 Credits
0 Reputation

Question Tag Cloud

adl2099 (54) Alarm Console (53) alarms (70) alarm template (58) API (35) Automation (144) automation scipt (65) Automation script (95) backup (54) Cassandra (142) cloud (37) Connector (44) Correlation (42) Cube (114) Dashboard (134) Dashboards (136) database (64) DataMiner Cube (37) DIS (53) DMS (48) DOM (68) driver (48) DVE (43) Elastic (73) Elasticsearch (99) elements (49) Failover (90) GQI (51) HTTP (45) IDP (55) low code app (70) low code apps (43) MySQL (50) protocol (145) QAction (58) resources (35) security (71) SNMP (56) SRM (267) SRM resources (39) timeout (35) trending (66) upgrade (44) Visio (373) Visual Overview (290)
Privacy Policy • Terms & Conditions • Contact

© 2023 Skyline Communications. All rights reserved.

[ Placeholder content for popup link ] WordPress Download Manager - Best Download Management Plugin