Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have a field wich is text, can'i get his num value within set analysis without reloading the app? i want exactly something like this:
=num(count({1 <NUM(CRMB)={'*'}-{40, 41}}>}MvtB),'# ##0')
It's possible?
Thank you in advance.
@JMAROUF the try below
=num(count({1 <CRMB={'*'}-{'40*', '41*'}>}MvtB),'# ##0')
@JMAROUF can you give an example from the count({1 <NUM(CRMB)={'*'}-{40, 41}}>}MvtB) text result ?
@JMAROUF may be you can try below
count({1 <CRMB-={'40', '41'}>}MvtB)
or
count({1 <CRMB=-{'40', '41'}>}MvtB)
Hi @Taoufiq_Zarra ,
it doesn't work, with if() the formula is:
count(if(NUM(CRMB)<>(40 AND 41),MvtB)) the result is: 674 266
i'am looking for something like that with set analysis.
the field CRMB is text, i want his num value within set analysis.
@JMAROUF why you want num when you are just giving any specific value in set?
@Kushal_Chawda I want any numeric value else 40 and 41, but the field is text such 40, or 40,0 .....
@JMAROUF did you try what I suggested?
Yes but it doesn't work, i have some values like this: '40,0000'
@JMAROUF the try below
=num(count({1 <CRMB={'*'}-{'40*', '41*'}>}MvtB),'# ##0')