I have a Text Object with the following expression in it:
= 'Total AUM' & '
'& Money(Sum(If(epic_issue_type='Epic' and project_name<>'PMO Test' and project_name<>'PMO IMS Pipeline' and epic_status<>'Not Required' and epic_status<>'Done', epic_cf_estimated_aum)), '$ #,##')/1000000000 & ' '& 'B'
The text box is totaling epic_cf_estimated_aum, I would like the text box to be dynamic in the sense that if the AUM falls in thousands, millions, billions, or trillions the B on the end of the equation will change to K, M, or T. Right now I hard coded the equation to display the B i want it to change as the number either goes up or down.
If someone can let me know if this is at all possible? If so, can someone help me create a new expression or maybe it is just an add on to the one above?
Unfortunately is this not implemented in that way..
num(Expression / 1000, '#.##0 k') for thousands
num(Expression / 1000000, '#.##0,0 m') for millions
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
To make the code in your text box leaner you could store the expression in a variable
vTotalAUM =Money(Sum(If(epic_issue_type='Epic' and project_name<>'PMO Test' and project_name<>'PMO IMS Pipeline' and epic_status<>'Not Required' and epic_status<>'Done', epic_cf_estimated_aum)), '$ #,##')
Then in your text box you could write something like:
Thank you for the post. But have you had success with the formula you suggested. I tried to use it in my Qlikview and it doesn't seem to be working for me. Wondering if i am doing something wrong.
