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

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!

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. 

2 replies

MPH2Author
Level 4
March 12, 2025

I forgot the image...

 

Translate
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. 

Translate