Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have two fields like below
Account, qty
A,100
B,200
,200
C, 500
Along with it I have a field whose value is input by user - Sales
I have an expression field - Sales*sum(Qty)/sum(total(qty))
If the value of expression is less than a threshold and the account field is blank , I would like to delete that row and calculate the expression again.
Let me know how this can be done using set analysis or any other method.
Hi,
The following might work.
You can try an expression that you hide that returns 1/0 for show/hide row;
Then use dimension limits to only return 1's and not show Others;
Cheers,
Chris.
Hey,
Deletion of row will work. However, I am more confused about how to recalculate my expression