Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
variable= sum(Cost)/ sum( SellingPrice) // -- result is in percentage
I need to display the count of product whose percentage is equal to 5.5%
= count( {<$(=$(Variable))={'5.5'}>}Product)
I am writing above expression, but not getting correct answer
Thanks
Hi. Try this
count( {< Product = {"=sum(Cost)/sum(SellingPrice)=0.055"}>} Product)