Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel1908
Creator
Creator

Formula does not work

Hello Together, 

The below formula doese not work.
Can you help?

=Count({<[Price-3]-={[Price-1]+[Price-2]},[ReturnLabel]={'A*'}>})Material&Shorttext)

Count all Price-3 which do not match with the total of Price-1 + Price-2 and have Return Label beginning wich A*.

Kind Regards, 
Daniel

 

10 Replies
MayilVahanan

Hi

Try like below

if("Price-3"-("Price-1"+"Price-2") >1,1,0) as L1Vergleich

=Count({<L1Vergleich={1},[ReturnLabel]={"A*"}>})Material&Shorttext)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.