Need to create a chart that shows cost of licenses per user | Adobe Higher Education
Skip to main content
Level 4
March 12, 2025
解決済み

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

  • March 12, 2025
  • 1 の返信
  • 437 ビュー

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

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 の返信

MPH2作成者
Level 4
March 12, 2025

I forgot the image...

Alex_Di
Alex_Di回答
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.