Need to create a chart that shows cost of licenses per user | Community
Skip to main content
Level 4
March 12, 2025
Solved

Need to create a chart that shows cost of licenses per user

  • March 12, 2025
  • 1 reply
  • 441 views

I am working with a coworker to create a report that will show the cost of each license type that users have tied to their account. What we are trying to do is show the license associated with a user and the cost of that license in a column. The problem is that a custom calculation field isn't showing the cost of any licenses, and as a result, there is nothing to show in a report. Is there a way that we can do this, or is it something that we would need to incorporate something like Fusion into? Below is a screenshot of what we are using to call a field that should be providing license cost data, but is not. Is there something in that code that is incorrect or being called in the wrong way?

 

Thank you!

Best answer by Alex_Di

Hi MPH2, 

 

So the text shown is not what the IF statement always needs to look for.  I used the following to find out that "Standard" shows as "F". 

 

displayname=License Cost
valueexpression={licenseType}
valueformat=HTML

 

So try using this

displayname=License Cost
valueexpression=IF({licenseType}="F","1234","")
valueformat=HTML

 

If this helps please consider marking as correct. 

1 reply

MPH2Author
Level 4
March 12, 2025

I forgot the image...

Alex_Di
Alex_DiAccepted solution
Level 3
March 12, 2025

Hi MPH2, 

 

So the text shown is not what the IF statement always needs to look for.  I used the following to find out that "Standard" shows as "F". 

 

displayname=License Cost
valueexpression={licenseType}
valueformat=HTML

 

So try using this

displayname=License Cost
valueexpression=IF({licenseType}="F","1234","")
valueformat=HTML

 

If this helps please consider marking as correct.