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

[MPH2]

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!

[MPH2]

I forgot the image...

 

[Alex_Di · Accepted solution]

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.