Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, @ Franky_h79 Andrey_krylov
i am using
below expression its working fine in listbox. where as rate filed is coming from database directly.
=Aggr(Only({<[Rate] = {"<=0.97>=1.03"}>} [ Code]), [ Code]) [listbox expression]
but now the issue is rate column is not coming from db . so we need to caluclate on the fly.
so i used this in the script to caluclate rate
Num([ AmountB]/[ AmountA], '#,##0.00%') as [Rate],
so now my requirment is ... i want to replace the rate with above expression to be used in listbox.
=Aggr(Only({<[Rate] = {"<=0.97>=1.03"}>} [ Code]), [ Code]) -- here how can place rate exression instead of direct rate
thanks
sony
its showing null 😞
i need to use that in listbox expression
This could be because of granularity mismatch. Try like:
Aggr(
If( Sum([ AmountB]/[ AmountA])<=0.97
and
Sum([ AmountB]/[ AmountA]) >=1.03 , [ Code])
, [ Code])
If even this doesn't help. Try to share your sample app.
I think it should 'or' instead of 'and' and the Only should be kept in case there is a Code with multiple AmountA or AmountB's.
=Aggr(Only(If([AmountB]/[AmountA]<=0.97 or [AmountB]/[AmountA]>=1.03, [Code])), [Code])
not working
hi,Tresesco
PFA. when open the app
right side u can see two listbox one is for red count one is for green count... whenever i select red count list box value it should display red value in table.
its not alternate solution.. because i calucalte in the script.. that field if i use in the table its not giving me correct result.
and that listbox is mapped to table so when i do selections in listbox the table is not showing the coresponding values.