num() function within set analysis

[JMAROUF]

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.

[Taoufiq_Zarra]

@JMAROUF  can you give an example from the count({1 <NUM(CRMB)={'*'}-{40, 41}}>}MvtB) text result ?

[Kushal_Chawda]

@JMAROUF  may be you can try below

count({1 <CRMB-={'40', '41'}>}MvtB)

or

count({1 <CRMB=-{'40', '41'}>}MvtB)

[JMAROUF]

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.

[JMAROUF]

Hi @Kushal_Chawda 

the field CRMB is text, i want his num value within set analysis.

[Kushal_Chawda]

@JMAROUF  why you want num when you are just giving any specific value in set? 

[JMAROUF]

@Kushal_Chawda  I want any numeric value else 40 and 41, but the field is  text such 40, or 40,0 .....

[Kushal_Chawda]

@JMAROUF  did you try what I suggested?

[JMAROUF]

Yes but it doesn't work, i have some values like this: '40,0000'

[Kushal_Chawda · Accepted solution]

@JMAROUF  the try below 

=num(count({1 <CRMB={'*'}-{'40*', '41*'}>}MvtB),'# ##0')