Selection criteria

[Karim_Khan]

Hi Team,

   I wanted to do calculation for finding bookings.

Which will be like

SUM([Sales Level2/[Sales Level1])

Its a dynamic value.Pls suggest

Whenever I click on Sales Level 1 and Sales Level 2 then it should give the calculation.

Regards,

KK

jagan‌gwassenaar‌MRKachhiaIMP‌ashfaq_haseeb‌Kush141087‌

[Karim_Khan]

Hi Kush,

   pls jst explain me

=Concat(DISTINCT chr(39)&  [Sales Level 1]& chr(39),',')

how above expression works

[Kushal_Chawda]

I have used the concat function to associate the possible Field values or selected Field values, So that I can pass this values in Set Expression

Like when you do set analysis ,you need to write  Field ={'1','2'....}

But we need to associate all values in single quotes which is done using chr(39)

[Karim_Khan]

so chr(39) is a in built function or what?

[Kushal_Chawda]

Yes,it is inbuilt

[Karim_Khan]

ok Got it Tnx yaar

[Kushal_Chawda]

welcome bro