Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
how to create such a calculation to
in the column was calculated
sum ()
Enterprise 1 - 100 (minimum value of the Sample)
......
Enterprise 3 - 300
Please, see the attachment and let us know if it is correct!
You can find my solution in the green column.
KR
Elena
Please, can you explain your question in a more detailed way?
try, in summary
we need to get
FOR Enterprise 1 = sum (Price for Sample 1), ie. To the field Sample: sample 1 <sample 2 and sample 3 - to present it as a serial number. (Min String) and = 100
For Enterprise 2 = sum (Price for Sample 4), ie. To the field Sample: Sample 4 <5 sample (Min String) and = 400
Hi,
Use Class Function.....
Examples:
class( var,10 ) with var = 23 returns '20<=x<30'
class( var,10 )
here 10 is interval.
if var =23 , then if your data of field start from 10 then after interval of 10 , 23 lie between 20 to 30.
so
var=23 return 20<=x<30
the meaning of this
Sum({<Sample = MinString(Samle)>} Price)
the meaning of this
Sum({<Sample = MinString(Samle)>} Price)
This should be the correct formula, but it seems it doesn't work
MinString({<Sample={"$(=minstring(Sample))"}>} Price)
Hi,
Can you attach the sample data.
so that we can help you in better way.
Sub2u
should ideally be so
thank
thank, this is something )