Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
TomBond77
Creator III
Creator III

Division not working

Hi experts

Revenue for a material: 100 USD

Quantity of that material: 5

Formula: Sum([Revenue] / [Quantity])  results in '-'

Any ideas?

Many thanks for your help.

Tom

2 Replies
PrashantSangle

is it USD text appended to Revenue value??

if that is the case then you have to remove string from you value.

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
tm_burgers
Creator III
Creator III

 Sum([Revenue]) /  Sum([Quantity])